Article ID: 2627824 - View products that this article applies to.
In Microsoft Access 2007 and Microsoft Access 2010 when you attempt to programmatically print a form or report and use the Printer.Copies property to assign the number of copies, only one copy prints, even though you specified multiple copies.
Microsoft is aware of this problem in Microsoft Access 2007 and Microsoft Access 2010.
The following workarounds can resolve the issue:
Workaround 1: Use the PrintOut action of the DoCmd object
For example, use the following code for the click event of a button on your form:
Workaround 2: Send the same report to the printer multiple times
Paste the following in the click event of a button on your form:
Add the following code to a module in the database:
For more information on working with printer settings for forms and reports refer to:
How to Work with Form and Report Printer Settings
Steps to reproduce:
1. In a new blank database in Access 2007 or Access 2010 create a blank report, "rptTest". Add a label to the details section with the text "Test".
2. Create a new module and paste the following code in the module:
3. Call the PrintReport procedure and provide the name of the report and the number of copies to print; for instance:
Results: Only 1 copy prints
(http://go.microsoft.com/fwlink/?LinkId=151500)for other considerations.
Article ID: 2627824 - Last Review: October 12, 2011 - Revision: 1.0