Conditional formatting

[avarusbrightfyre]

I'm trying to set a continuous form to display the background of a field in red if the date is within 2 weeks and a separate field on the form is blank.

[DATE]<Date()+14 and [DATE MAILED] = "" (also tried null)

Using just the date portion works fine. Dates within two weeks show up red. I really need it to show up red only for dares within two weeks whose [DATE MAILED] is blank.



How do I do this?

[pbaldy]

Try

[DATE]<Date()+14 and IsNull([DATE MAILED])

[avarusbrightfyre]

That worked great! Thanks!

[pbaldy]

Happy to help. Nothing is ever "=" to Null, which can perhaps be best defined as unknown. You have to test for it with IsNull(), Nz(), etc.