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.