I have a form that receives its data from a number of queries. When there is no 'null' fields, everything works fine. My problem is when one of the queries returns a null value for a field, the form shows a completely blank page, the labels and boxes don't even print. I have tried the function nz() in the queries and on the form but to no avail. I'm not sure if I'm using the function correctly or not, where is the right place to use that function?. Any ideas or help would be extremely appreciated.

I am having the very same problem with my reports. I have also tried using the nz() function and it is not working! I was also wondering if there was a particular place to use this function or possibly in multiple places, e.g. table, query, form, or report??
I would also like some help with this area.

Kirsten

If this is in a form, use the DCount function upon opening the form to verify if there are any records being returned by the query. Then use the results to determine if the form should open or not. If the DCount function returns "0" then there were no records that matched the criteria given, so don't open the form, maybe give a message saying "There were No Records".

If this is in a report you can use the On No Data event of the report to stop the report from opening.

HTH
RDH

[This message has been edited by R. Hicks (edited 03-27-2000).]

[This message has been edited by R. Hicks (edited 03-27-2000).]