How to get the label back color to change if the check box is TRUE?

I have 24 check boxes that I am working with. If the check box is "TRUE" I want the lable back color to change color.
I attached a simple DB and image to better explain this problem.

I have tried may ways to get the label back color to change, but can't do it.

Any help is appreciated.
LabelColor.jpg
Database9.accdb
cssc1Asked:
Who is Participating?
 
PatHartmanCommented:
If you change the label to a textbox, you can get the conditional formatting to work.
0
 
Phillip BurtonDirector, Practice Manager and Computing ConsultantCommented:
I don't believe you can directly.

You could use a Toggle Button, and have different colors depending on whether you have clicked it or not (you can change the Pressed Color properties).

Alternatively, if you have to use a check box, you could use Format - Conditional Formatting to change (say) the ID Text box to a different color, based on the contents of the check box, but you can't use Conditional Formatting on Checkboxes or Labels.
0
 
cssc1Author Commented:
thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.