Printer prints multiple copies

[Guest]

I am running a report in Access 97 from VBA like this:
DoCmd.OpenReport "rptTGrantsAwardLetter", acViewPreview

Printing from this preview sometimes prints 2 or more copies of the report.
The copies are set to 1 in the printer dialog. This behaves the same on
several different printers. I tried printing directly with:
DoCmd.OpenReport "rptTGrantsAwardLetter", acViewNormal
but this seems to print multiple copies more often.

 

[SA]

Tom:

There's a element of a property called the prtDevMode that is part of a
report, where the number of copies is stored. This evidently has been set
to a number greater than two for the target report. What you might do to
change it is:

1.) Open the report in design mode. Choose File -> Page Set Up -> Page tab,
and select to use a specific printer, selecting something other than the
first printer instance that shows in the dialog (likely your default
printer,) and then Save the report.
2.) Repeat step 1, this time using the specific printer that is your default
printer; save the report
3.) Last, repeat one more time, this time selecting to use the Default
Printer and save the report.

That will clear the defaut copies that may have been stored in the report,
resetting it to 1.