Batch Print Multiple Access Reports with a Macro
Question details
The user wants to print multiple Microsoft Access reports using a macro.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- A macro opens several reports that need to be sent to a printer.
- Observed behavior
- Reports opened in Report view are displayed instead of being printed.
Make sure the reports are available in the Access database and that the intended printer is configured as the default printer. Locate the macro that opens the reports in the Navigation Pane.
Set each OpenReport action to Print
Use this method to send each report directly to the printer when the macro runs.
In the Navigation Pane, right-click the macro and select Design View.
Find an OpenReport action, select the report in Report Name, and change the View setting from Report to Print.
Repeat the View change for each OpenReport action that should print a report.
Save the macro, then run it from the Navigation Pane and check the printer output.

Print open reports with the PrintOut action
Use PrintOut when the macro needs to open a report first and then issue a separate print command.
Use WPS Office for everyday document and spreadsheet printing
WPS Office is a free, lightweight alternative with a familiar interface and support for common Microsoft Office formats, making it easy to move everyday documents and spreadsheets between suites. It does not run Access database macros or replace Access report printing.

Frequently Asked Questions
Why does my Access macro show a report without printing it?
The OpenReport action may be set to Report view. Open the macro in Design View and change its View setting to Print to send the report to the printer.
How can I print several reports in one macro?
In the macro's Design View, add an OpenReport action for each report and set each action's View to Print. Save and run the macro.
When should I use PrintOut instead of OpenReport with Print?
Use PrintOut when you want a separate print action for the active report, such as after opening it in Print Preview. Use OpenReport with View set to Print for direct printing.
Which printer will the Access macro use?
The report is sent to its configured printer, typically the default printer. Check the default printer and the report's page setup if output goes to the wrong device.




