Supress printing of empty reports

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kellogg - 26 Oct 2005 19:03 GMT

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?

Reply to this Message

Marshall Barton - 26 Oct 2005 19:37 GMT

>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?

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.

Signature

Marsh
MVP [MS Access]

Reply to this Message