Visible property on Report

[LeAnn]

Access 97

I have a form with a button that opens a report using a macro. The macro
has a where condition to display the matching record. When the report opens
I want to make a label control visible based on a text box (data field).
I wrote an IF statement for the on Open event of the report:

If Me!XYZ <> "N/A" Then
Me!lblXYZNote.Visible = True
End If

I get an error saying that the expression refers to an object that doesn't
have a value. It is a textbox control with the control source being a field
in the table.

How should I go about this?
Thanks

 

[Alex Dybenko]

Try to use Format event of corresponding report section

 

[LeAnn]

Thanks - that did the trick. Forgot about that event.