Determine the visibility of an image in a report 1

[bryansisk]

I have a report that has a couple of selections that have to be circled. What I did was simply draw some ovals in word and paste them into my access report (the images are .bmp). Now I want to set the visibility of the images based on the numeric values in the [exp_cat] field. Here is a sample of what I did...

Private Sub Report_Open(Cancel As Integer)
If Me.Exp_cat = 1 Then
Me.circle2.Visible = False
Else
Me.circle2.Visible = False
End If

end Sub

The problem is that I keep getting the error "You entered an expression that has no value" - I have tried many different angles and nothing seems to work. Any help would greatly be appreciated.

 

[cghoga]

Try putting your code in the On Format property of the detail section.