Supress printing of empty reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The answer to this question is probably so easy I should be shot for asking.
I have a number of reports that are set to print with the click of a button.
Problem is that some of the reports do not contain any information except for
the header, footer and some unbound text boxes. How can I keep these reports
from printing and have my macro that prints the reports continue on to the
next report?
 
Kellogg said:
The answer to this question is probably so easy I should be shot for asking.
I have a number of reports that are set to print with the click of a button.
Problem is that some of the reports do not contain any information except for
the header, footer and some unbound text boxes. How can I keep these reports
from printing and have my macro that prints the reports continue on to the
next report?
Click to expand...


I don't think you can do this with macros.

Each report should use it's NoData event procedure to Cancel
the report using:
Cancel = True

Then the form that opens the report needs to trap and ignore
error 2501 so you don't get a Action was Canceled message
box.
 
Back
Top