Null entries on custom dialog

[uplink600]

I have a custom pop up dialog on which the user enters certain criteria to search for records in the database. They can enter criteria such as customer name, account number, sales-person etc. On clicking the search command button the query is run and a report printed detailing all the records found.

On the report header I have created a section that details the criteria that was entered in the search dialog. This is shown on the enclosed word doc.

This section will detail the criteria that was entered but otherwise is blank. I would like the other criteria to say "Not Specified" on the report.

Any advice please.

Thanks

VC

 

[maxmangion]

use the IIF function to check if it is null and set "Not Specified" in the True part of the IIF function

 

[maxmangion]

e.g.

=IIF(isNull(Fieldname), "Not Specified", "Specified")