datasheet conditional formatting not working on one field only

[theDBguy]

oh it seems your earlier suggestion has worked - I stupidly tested it on "no" when none of the fields actually contain the result "no"...

So by referencing the column name (which I've renamed from combobox to "Parking Booked Col") has worked, but referencing the database field itself does not - is there a reason for this?

Hi. Glad to hear you're making good progress. It's hard to say why the other way doesn't work without knowing more data. For example, what is the Record Source of your Form?

 

[Statick]

oh it's not letting me upload my DB... I'll try to share it another way

 

[theDBguy]

oh it's not letting me upload my DB... I'll try to share it another way

You could try stripping out all the other objects not needed to troubleshoot the problem. Maybe you can just leave the one table and one form, if it works.