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! :banghead:
Please could any of you super helpful people put me out of my misery?
Suzi
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! :banghead:
Please could any of you super helpful people put me out of my misery?
Suzi