I have a Report that prints test scores. When there is no test data I have the on no data event of the report get the appropriate info from the entry form and make a text box with a message in it visible other wise it is not visible.


My complaint is all the error text that appear on the report. Do I handle this at the query level with the Nz function ?

The Text box message states "No Test Data Found at " & [Location] & " for this Quarter""

I would just like to clean up the appearance of the report. Zeros or nothing would look better than the error text.
Rick

Hi,
you could just hide the whole section which prints the erros on the on no data event if you want and only display the one which holds this textbox. Check this earlier discussion for more info.
HTH
Good luck

perfect solution, thank you.

You're welcome.
Good luck on future projects!