<div>
Thanks! &nbsp;Worked if I rearranged the IIf to put Null if no false, and I get because I then display my merged text. &nbsp;But what if I just want to diaplsy an image? &nbsp;What do I put in the TRUE part?<br />
<br />
=IIf([tblContractAiringDat<wbr />es subreport].[Report].[HasDa<wbr />ta],DLookU<wbr />p(&quot;VendorA<wbr />ddressAddr<wbr />1&quot;,&quot;tblVen<wbr />dor&quot;,&quot;Vend<wbr />orName= '&quot; &amp;&nbsp;[Station] &amp;&nbsp;&quot;'&quot;) &amp;&nbsp;&quot; Specific Airdates for &quot;&nbsp;&amp; [Start Date] &amp;&nbsp;&quot; - &quot;&nbsp;&amp; [Expiration] &amp;&nbsp;&quot; contract:&quot;,Null)
</div>


Thanks!  Worked if I rearranged the IIf to put Null if no false, and I get because I then display my merged text.  But what if I just want to diaplsy an image?  What do I put in the TRUE part?

=IIf([tblContractAiringDates subreport].[Report].[HasData],DLookUp("VendorAddressAddr1","tblVendor","VendorName= '" & [Station] & "'") & " Specific Airdates for " & [Start Date] & " - " & [Expiration] & " contract:",Null)

<div>
<div class="content wysiwyg-content">
I have a second page on an Access report that I do not want shown if there is no data in the subreport that makes up that second page. My subreport does not appear if it is empy so I'd like the text above it to also not appear. &nbsp;I'd really not even like a second page, if possible. &nbsp;<br />
My subreport is tblContractAiringDatesSubr<wbr />eport. &nbsp;<br />
The text I&quot;m trying to hide is Text165.<br />
<br />
I cannot get the syntax to work:<br />
Private Sub tblContractAiringDateSubre<wbr />port_Enter<wbr />()<br />
If Me.Report.HasData Then<br />
&nbsp; &nbsp; Me.Text165.Visible = True<br />
&nbsp;Else<br />
&nbsp; &nbsp; Me.Text165.Visible = False<br />
End If<br />
End Sub<br />
<br />
I'm not even sure if this is where I should be putting the If statement. <br />
But also not sure the subreport is being reference correctly.<br />
Thanks in advance for any help.
</div>
</div>


I have a second page on an Access report that I do not want shown if there is no data in the subreport that makes up that second page. My subreport does not appear if it is empy so I'd like the text above it to also not appear.  I'd really not even like a second page, if possible.  
My subreport is tblContractAiringDatesSubreport.  
The text I"m trying to hide is Text165.

I cannot get the syntax to work:
Private Sub tblContractAiringDateSubreport_Enter()
If Me.Report.HasData Then
    Me.Text165.Visible = True
 Else
    Me.Text165.Visible = False
End If
End Sub

I'm not even sure if this is where I should be putting the If statement. 
But also not sure the subreport is being reference correctly.
Thanks in advance for any help.

If subreport has no data, do not show text

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.