I have an image on my report that I want to make visible only when a yes/no field is true. The yes/no field is a hidden text box called txtTried. The code I've been trying to use is:
- If Me!txtTried = True Then
-
Me.imgBerry.Visible = True
-
Else: Me.imgBerry.Visible = False
-
End If
I got this to work on a form by using the same code in the Form_Current event, but it won't work in my report. Have tried it in the Report_Current, Report_Activate, Report_Load, Report_Open, and Detail_Format events, nothing happens in any of those except the Report_Open one gives an error saying can't find the field, control, or property, and in debug mode the first line of code is highlighted.
Not sure if I'm making sense, can anyone help me with this?