I have a report that lists various medications. I am wanting a text box to only be visible when the end date is not nulled. I have this code:
If IsNull(Me!EndDate) Then
Me!Text42.Visible = False
Me!Text42.Visible = True
Which works along the same idea, however if only one of the lines meets the criteria it follows it for ALL the records. Is it possible (and how) to make this only show for the records that meet the criteria? I currently have the code linked to On Open Event of the report (it happens to be a subreport of another report). Thanks for all help and advice.