Printing Odd Pages Only

[Shelley]

I want to print every other page (odd pages first) and
then have the user be able to re-load the paper so they
can then print all the even pages on the other side. I
have been scouring the newsgroup for help and have found
how I can tell if a page is odd or even (below) but don't
know where to go from here.

Private Sub PageFooterSection_Format(Cancel As Integer,
FormatCount As Integer)

'OddEven is a control in the Page Footer.
If Me.Page Mod 2 = 0 Then
Me.OddEven = "Even"
Else
Me.OddEven = "Odd"
End If

End Sub


Thank you in advance for your help,
Shelley

 

[Larry Linson]

My printer properties dialog has a check box for "manual duplexing" and it
will automatically do what you want. Have you checked to see if your and/or
your users' printers have this option?

Larry Linson
Microsoft Access MVP

 

[Shelley]

I can't find that with my printer (Canon BJ-200 ex). I
also tried an HP Laserjet 4000 and couldn't find it. What
printer driver are you using?

 

[Larry Linson]

The printer to which I referred is an Epson C-80 Inkjet. I have not used
Canon printers and it has been some time since I was in a shop with an HP
Laserjet. IIRC, my HP g35 Multifunction has a similar option.

Other than that, the print dialogs usually have a box where you can specify
the specific page numbers. If you have a great many pages, however, it could
be tiresome to enter 1,3,5,7...

Larry Linson
Microsoft Access MVP