Question Conditional formatting issue

[Johnny Drama]

Hello all,

I'm trying to get a field in a form to turn the text red when certain conditions are met.

I have a due date field and a received date field. I would like the text in the due date to turn red if the due date is the current day or has past AND if the received field is blank.

The current expression I'm using is (Date()>=[duedate]) And [receivedate]=0 but that doesn't seem to work. I've also tried ([Date()]>=[duedate]) And [receivedate]=0...no dice there either.

Any help would be appreciated.

Thanks!

 

[scalextric59]

I think you need to use IsNull instead of zero

(Date()>=[duedate]) And isNull( [receivedate])

 

[Johnny Drama]

That did it. I was looking at the wrong control. Thanks much!