Show/Hide 2 Images on a report based on Yes /No field in query

[DeltaD]

Hi guys!
I've been beating my head against this one for a while.
I've got a query with a report attached to it to generate signs for my workplace. How would I go about showing or hiding 2 caution signs based on a yes / no checkbox? Is there VBA code for this?

The table underneath has a Yes/No field dedicated to this, and I'd love to have it appear / disappear on a "per record" basis

I can post a sample database if needed
Thanks!

 

[arnelgp]

you can't do that when in Report View of your report?
you need to be in the Print Preview.
you also need to add the YesNoField to the report (if you must hide it
set it's Visible property to No).

add code to the Detail Section (of report) On Format Event:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
If Me!YesNoField Then
    Me!Image1.Visible = True
    Me!Image2.Visible = True
Else
    Me!Image1.Visible = False
    Me!Image2.Visible = False
End If
End Sub

 

[DeltaD]

I have not tried the on format event!
When I added the code as a module before, the text fields would throw a #Type error back.

 

[Gasman]

I would try

Me.Image1.Visible = Me.YesNoField

Just another way to do it?

 

[arnelgp]

see this demo to explain better.
view the report in Print Preview.

 

[DeltaD]

Thanks everyone!
I'll give it shot when I get back to a computer and report back!

 

[DeltaD]

see this demo to explain better.
view the report in Print Preview.

That solution worked perfectly! Now all i need to do is figure out how to stop every other report item from being light grey

Thanks @arnelgp!

 

[arnelgp]

rom being light grey

perhaps you are talking about the Alternate Color of the Detail section of the report?
go in design view. Click on the Detail Band of the report on its property, set the Alternating Color to No Color.

 

[DeltaD]

that is EXACTLY what it was!

 

[arnelgp]

goodluck, boss