Conditional Formating (1 Viewer)

MarionD

Registered User.
Local time
Today, 08:58
Joined
Oct 10, 2000
Messages
421
Hi All,

I have a form in datasheet with the fields "Date In" and "Date out" among other.

I want to be able to Change the backcolour of the "Date In"
to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting, but now I only want to apply this formatting IF the "Date Out" is empty.

Can someone tell me if this is possible? Access 2007.

Thanks a mil
MArion
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 01:58
Joined
Aug 30, 2003
Messages
36,118
You can try adding " And DateOut Is Null" to your condition.
 

MarionD

Registered User.
Local time
Today, 08:58
Joined
Oct 10, 2000
Messages
421
Perfect! Thanks I didn't realize you could write more than one condition in.

Thanks again... you just saved me hours!
M
 

pbaldy

Wino Moderator
Staff member
Local time
Today, 01:58
Joined
Aug 30, 2003
Messages
36,118
Happy to help!
 

Users who are viewing this thread

Top Bottom