Return onnodata value in unbound report field

[jwkolker]

I am trying to have an unbound field return text to the field when the report has no data.

I created an unbound field and tried this

=IIf([Customer_name]Is Null,"No Customers to Report","")
[\code]
Meaning If field Customer_name has nodata then return No Customers to Report message to the unbound field or if there are customers in the report return nothing to the unbound field.

This is not working - I get No Customers to Report when there is data, and #error when there is no data..

Please help.

JoKo John Kolker
Programmer
jwkolker@comcast.net

 

[CosmoKramer]

Try this:

=IIf(IsNull([Customer_name]),"No Customers to Report","")