View Single Post
Old 08-29-2019, 04:09 AM   #1
Newly Registered User
Join Date: Aug 2019
Location: Durham, UK
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Suzi is on a distinguished road
Conditional formatting of a report field based on outcome of two fields (Access 2016)

Hello everyone!

Long time reader, first time poster!

I have done several searches to find the answer I need to my conditional formatting nightmare but I can't find an example which matches mine and my own thoughts aren't yielding anything.

I have two fields: "car reg" and "external". If car reg is blank and external is true I want the car reg field on a report to have a shaded background.
I've tried many different ways and none have worked.

Currently, in my conditional formatting box I have:

Expression is: ([tblContacts.External]=True) And ([tblContacts.Car Reg] Is Null)

but no amount of changing 'true' to Is not null, 1, "true" and all of the other iterations I can think of changes the colour of the cells!

Please could any of you super helpful people put me out of my misery?


Suzi is offline   Reply With Quote