Conditional Formating

[MarionD]

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]

You can try adding " And DateOut Is Null" to your condition.

 

[MarionD]

Perfect! Thanks I didn't realize you could write more than one condition in.

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

 

[pbaldy]

Happy to help!