If statement with visible function in report?

[Noah114]

How would I create a function that utilizes an "IF" statement which turns the visible marker from yes to no or no to yes on a image in a report?

 

[dhookom]

You can use code in the On Format event of the section of the report containing the image. Something like:

If Me.txtSomething = Something Then
    Me.imgMyImage.Visible = True
  Else
    Me.imgMyImage.Visible = False
End If

or

   Me.imgMyImage.Visible = Me.txtSomething = Something

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]