Printing Problems

Batch Print Multiple Access Reports with a Macro

Phi Hung VoPhi Hung Vo Nov 20, 2026 868 views

Question details

The user wants to print multiple Microsoft Access reports using a macro.

How to Batch Print Multiple Access Reports with 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.
Before you start

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.

Solution 1Recommended

Set each OpenReport action to Print

Use this method to send each report directly to the printer when the macro runs.

1
Edit the macro

In the Navigation Pane, right-click the macro and select Design View.

2
Change the report view

Find an OpenReport action, select the report in Report Name, and change the View setting from Report to Print.

3
Update the remaining reports

Repeat the View change for each OpenReport action that should print a report.

4
Save and run

Save the macro, then run it from the Navigation Pane and check the printer output.

Set each OpenReport action to Print
Print versus Report view: Print sends the report to the printer; Report view opens it on screen without printing it.
Free Microsoft Office alternative

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.

Print documents and spreadsheets from a familiar interfaceOpen and edit common Microsoft Office formats, including DOCX, XLSX, and PPTXUse a free, lightweight suite for everyday office workMove compatible files between WPS Office and Microsoft Office
microsoft office alternative - wps office

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.