Conditional Format with Blank Fields in Report 1

[awl]

I am seeking help with a Conditional Formatting issue. I want the [VisitDate]field in my report I want to display a "yellow back filled" where there are no entries, that is when the field as no data in it. For the "Conditional 1, I selected "Expression Is". Then I inserted: IIf(IsNull([VisitDate])=False,"0",[VisitDate]). I have used a couple of other formats, however with no luck. Any suggestions would be helpful. Thanks.... Curtis....

 

[dhookom]

I think your expression should be:
IsNull([YourField])
Nothing else should be necessary in the expression.

Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[awl]

You are very correct. Thanks for the good suggestion. Curtis.....