Print the First Page of Each Access Report Group from a Different Tray
Question details
Print the first page of each client's grouped Access report on letterhead and later pages on standard paper.

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

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.

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.




