Printing Problems

Print the First Page of Each Access Report Group from a Different Tray

Huma Ashraf ChHuma Ashraf Ch Nov 20, 2026 869 views

Question details

Print the first page of each client's grouped Access report on letterhead and later pages on standard paper.

Print the First Page of Each Access Report Group from a Different Tray
Product
Microsoft Access
Device & OS
not provided
Scenario
A grouped report contains multiple clients, and each client's first page needs paper from a different printer tray.
Observed behavior
Each client's first report page should use the letterhead tray, while subsequent pages use the standard-paper tray.
Before you start

Load letterhead and standard paper into their respective trays, and check the printer driver's preferences for a first-page or different-paper-source option. Identify the report's client ID field and a table or query that contains the client IDs.

Solution 1Recommended

Print each client as a separate filtered Access report

Use this approach when the printer driver can select different trays for the first and subsequent pages of each print job.

Printing a separate report for each client makes that client's first page the first page of a new print job. The printer driver, rather than Access grouping alone, must support the different-tray setting.

1
Configure the report printer

Open the report in Design View and select Page Setup. On the Page tab, choose a specific printer, then open its properties or printing preferences. Select the letterhead tray for the first page and the standard-paper tray for later pages; option names vary by driver.

2
Add a VBA printing procedure

Open the VBA editor with Alt+F11, choose Insert > Module, and add the following example. Replace YourReportSource and YourReportName with your actual table or query and report names. This example assumes ClientID is a numeric field available in both the source and report: Public Sub PrintClients() Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("SELECT DISTINCT ClientID FROM YourReportSource WHERE ClientID Is Not Null", dbOpenSnapshot) Do While Not rs.EOF DoCmd.OpenReport "YourReportName", acViewNormal, , "[ClientID]=" & CLng(rs!ClientID) rs.MoveNext Loop rs.Close Set rs = Nothing End Sub

3
Test the tray selection

Save the report and run the procedure from the VBA editor. First test with a small set of clients, including one whose report has multiple pages, and confirm that each client's first page uses letterhead and later pages use standard paper.

Print each client as a separate filtered Access report
Printer support is required: If the driver does not offer different sources for the first and later pages, this procedure alone cannot select the trays. Check the printer documentation or driver options for an alternative.
Free Microsoft Office alternative

Work with Office documents using WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with Office documents. Its format compatibility makes it easy to move existing files into WPS, although it does not configure Microsoft Access reports or replace Access VBA.

Create and print documents using familiar editing toolsOpen and edit Microsoft Office formats such as DOCX and XLSXUse a lightweight office suite for everyday document workMove compatible Office files into WPS without starting from scratch
microsoft office alternative - wps office

Frequently Asked Questions

Why should I print each client as a separate report?

A printer's first-page tray setting generally applies to the first page of a print job, not the first page of every Access group. Opening the report separately with a ClientID filter creates a separate job for each client.

Where do I select the letterhead tray?

In the report's Page Setup, select the printer and open its properties or preferences. Look for an option for a different first-page paper source, then select the letterhead tray there.

What if my printer driver has no first-page tray option?

The VBA loop does not set different trays by itself. Check the printer documentation or driver preferences for another supported method, or ask the printer administrator about available tray controls.

Can I use the VBA example with a text client ID?

Not without changing the filter. The example uses CLng for numeric IDs; a text ID must be enclosed in quotes in the WhereCondition, with any embedded quotes escaped.