Form Button Background Color Dependency

[HT_Bob_Brick]

I've setup a database for a group of people to track instrument state. Attributes of an instrument are things like: Defects present, date of service work, software version and Is_Operable.

The Is_Operable field is a yes/no format in my instrument table.

I have a master form that lists the 5 instruments by means of 5 buttons - each button titled the name of the instrument. When you click on an instrument button an instrument specific form opens displaying all the associated attributes with that specific instrument.

Here is what I'd like to do:
In the master form, I would like the background color of the instruments buttons to be either red or green depending on if the Is_Operable is set to either yes or no in the instrument table.

Desired outcome:
When the user looks at the main form they can see which instruments work (green buttons) and which ones do not (red buttons). They can click on any of the red or green buttons to get specifics.

I think this is simple but after playing around with button event properties I've not been able to figure this out.

If there are better ways to do this, I'm also open for suggestions.



Thanks for the help.

[CJ_London]

I'm assuming your form is continuous since it otherwise should not be an issue.

buttons do not have conditional formatting so you cannot have variation of background colour in a continuous form as such but you can make the back transparent and have a textbox behind it where you can set conditional formatting