Get rid of printing msg on NoData

[Guest]

Hello -

I have a messagebox in the NoData event of reports as follows:

Private Sub Report_NoData(Cancel As Integer)
DoCmd.SetWarnings False
MsgBox "No data returned. Try changing dates."
Cancel = True
DoCmd.SetWarnings True
End Sub

At the same time my message pops up, an Access msgbox pops up saying "Now
printing 'ReportName' to the 'NameOfSystemPrinter' "

There is nothing sent to the printer; nothing printed, which there shouldn't
be.

How do I get rid of this useless msgbox?

Any help will be greatly appreciated!

 

[SA]

Sandy:

There's no easy way to get rid of that dialog. You can do so with a little
Windows api code which you can find at
http://www.mvps.org/access/api/api0037.htm