I have a report based on a query. The query contains a memo field titled "comments" and this field can contain lengthy information that I do not want to appear on my report. To avoid the cluster of information, I have created a label (appears as a hyperlink) with an on-click event that opens a form to display the "comments associated with that record. The label/form combination works nice, but not ALL records have comments, and I do not want the label to be visible for those records.
I tried adding code in the report's On Open event...
If IsNull(Me.Comments.Value) Then
Set ProdNotes.IsVisible = False
...but the code is not effective.