Print Duplexed Pages in Reverse Order in Access Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003, I created a 2-page report for someone who wants the report
to print duplexed. And it works fine, except….he is using a special “carbon
copy†paper and needs page 1 to print on the proper side. His printer prints
Page 2 first and then prints Page 1 on the back side. I need to do something
to get Page 1 to print first and print Page 2 on the back side.
I tested this on my HP4700dtn printer, and apparently duplexing works the
same on my printer, too. Microsoft Word has a print option feature called
“Reverse Print Order†(File – Print – Options button) and when I used that in
Word to test, I got the results I needed. I cannot find a similar feature in
Access to reverse the order that the pages print and still be duplexed.
I tried using some PrintOut code I found in this discussion group. The
pages printed in the order I needed but did not duplex. The code I tried was:


Dim strReport As String
Dim intPage As Integer

stDocName = "MyReport"

DoCmd.OpenReport strReport, acViewPreview

For intPage = 1 To Application.Reports(strReport).Pages Step 1
DoCmd.PrintOut acPages, intPage, intPage
Next intPage

DoCmd.Close acReport, strReport


Since this is a 2-paged report, I can do a workaround and, in Report Design
View, move my Page 2 to Page 1 so that Page 1 becomes Page 2. But I would
like to have a solution for if the report were say 4 or 6 pages.
I’d appreciate any help anyone can give me.
 
Just change the properties on the print option. There is an option for
printiing both sides.

Doing things like duplexing and such stuff is a printer function not an
access function.
There are printer options for pretty much every application on a computer.
 
Thanks for your response. I do have the option for printing both sides
already selected. I need to be able to control the order of the pages printed
so that Page 1 is on the top side of the carbon paper. I think I will just
have to do the workaround I mentioned about flipping the pages in my report
design. Thanks.
 
Back
Top