Report Pull In field

[Tim Eagle]

I want to pull in a field from a query into a report, if the record is blank
how do I get a default statement to go there in its place. Thanks.

Tim Eagle
http://www.croswellmich.com

 

[Guest]

Probably easiest to do it in the query. In the field where you want a default
value, instead of the field name, change it to an expression:

ChkValue: IIf(Nz([MyField],"") = "", "Default Message", [MyField])

Then make ChkValue the control source for the text box on the report.