Conditional Formatting of Yes/No in MS Access

Is there an easy way to do conditional formatting on a Yes/No selection?

IF check box is selected I want all font for that record to be red...

 

If you link the check box to an empty cell e.g. b6, the result in the cell will be true or false. You can then link the conditional format for the cell to be changed to the results.

formula is =ib6=true set your format. etc.

You need one link cell for each check box.

Hope this helps

Regards - Nic