Report Producing NULL values

socoolbrewster · February 13th, 2004, 11:28 AM

Hi

I am developing a database application using MS Access 2000 for a local charity. Having not used Access 2000 for quite a while my skill set is a little rusty, so I am hoping somebody will take pity on me with the following technical enquiry.

I have produced several reports that produced output based on several parameter queries. My problem is if a user inputs data that cannot be found a blank report is produced and some data values are stated as NULL values. How can I stop a report being produced when no related records can be found?

Gaz

joefawcett · February 13th, 2004, 11:34 AM

There are a number of ways, one is too use the onNoData event (I think it's called that, I don't have Access on this machine, it might be something similar) in the report to give a message to the user and cancel the report.

--

Joe

BethMoffitt · February 13th, 2004, 11:39 AM

Code:

Private Sub Report_NoData(Cancel As Integer)
 MsgBox "No data found for this report.", , "Report Cancelling..."
 Cancel = True
End Sub

Regards,

Beth M