Conditional Formatting with IIF IS NULL

[IH8XEL]

Hey guys. I'm trying to conditionally format a date field in a report. If the field in the record Is Null I want to return "No" if Not Null I want to return "Yes." Here is what I have so far:

IIf([fldName] Is Null,"No","Yes")

Doesn't work though; either shows the actual entry or a blank space, not "Yes/No"

Help?!?!?!??!?!?!?!?!?

 

[Joe4]

Conditional formatting is used to change the formatting properties (i.e. fill color, text color, bold, etc) of a field. It does NOT return a value. That would be a calculated field, not conditional formatting.

A calculated field on your report (or in the underlying query) would look like:

[COLOR=#333333]IIf(IsNull([fldName]),"Yes","No")[/COLOR]

For conditional formatting, you would simply use:

IsNull([fldName])

which returns True or False (Conditional Formatting is applied when condition is True)

 

[james_lankford]

IIf( trim( nz([fldName]) ) = "","No","Yes")

those are two double quotes