conditional formatting help please

[Guest]

Hello,

I am having trouble using the conditional formatting.
I want the background of the "End Date" to turn red when the "Start Date" is
entered and then for the red background to go away after an "End Date" is
entered. I used the expression ("Start Time" Is Not Null) and that made my
background red but I can't seem to figure out how to get the red background
go away. I tried a couple of diffrent expression like setting another
condition ("End Time" Is Not Null) but it didn't work. Can some please help
me find the right expression for what I need it to do???? THANKS!!!!

 

[John W. Vinson]

Hello,

I am having trouble using the conditional formatting.
I want the background of the "End Date" to turn red when the "Start Date" is
entered and then for the red background to go away after an "End Date" is
entered. I used the expression ("Start Time" Is Not Null) and that made my
background red but I can't seem to figure out how to get the red background
go away. I tried a couple of diffrent expression like setting another
condition ("End Time" Is Not Null) but it didn't work. Can some please help
me find the right expression for what I need it to do???? THANKS!!!!

The text string "Start Time" is certainly not null. Try changing the
delimiters to brackets so Access will know you mean the fieldname rather than
a literal text string:

([Start Time] IS NOT NULL)

John W. Vinson [MVP]