Printing Blank Report

[andrewm]

I am using a macro in access 2003 to import data, collate it into a report and then print the report to paper to go with customer orders. I have another program running this so that it runs on a schedule with no human intervention. My issue is that I can't seem to get it to not print if the report does not have any data in it. I have tried the condition in the macro:
Not IsNull([Reports]![In2Store Order Invoice]![txtOrder_Number])
but it still prints. Please help I have been on this for a couple of days now.

[apr pillai]

Copy and paste the following VBA Code into the Code Module of the Report:

Private Sub Report_NoData(Cancel As Integer)
     Cancel = True
End Sub

Save the Report with the Code.
Try printing the Report when there is no data for the report.

[andrewm]

That worked perfect. Sorry don't know much code so use macros and interface mostly.

Thanks heaps