Need image to be visible only when criteria is met. 1

[RobertIngles]

Hi all;

Trying to display a variety of bitmap images depending on content of a field on the form. I have started with a green "go" light - if the field text is "Pass" I want the image to display - if the field is "Fail" or "Testing" I want another image to be displayed.

Here is the code I have started with for Green - problem is that regardless of the field not saying "Pass" the image still appearing:

Private Sub Form_Load()
If Me.Launch_Test_Status = "Pass" Then
Me.GreenLight.Visible = True
Else
Me.GreenLight.Visible = False

End If
End Sub

Not sure what I am doing wrong here...
Thaks!!

 

[dhookom]

Is this a single form view or continuous? If it is single, you should place the code in the On Current event of the form rather than the Load.

Duane
Hook'D on Access
MS Access MVP

 

[RobertIngles]

Hi Duane;

It's a continuous form view...

 

[dhookom]

Then, all of the images in all of the visible records will be switched based on the record with the focus.

You can use conditional formatting and some other tricks to display different values and colors in a continuous form.

Duane
Hook'D on Access
MS Access MVP

 

[RobertIngles]

Thanks Duane - I am using conditional field formatting to differentiate between the various status's. Just thought green light if all three status's read "Pass" would be cool and great for quick visual ID (but mostly cool)...lol

Thanks again Duane - always nice to know you are here for guidance!

 

[dhookom]

You can actually give lots of visual clues with webdings or various wingding fonts and colors.

Duane
Hook'D on Access
MS Access MVP