How do I set up a report in Access to duplex print?

[Guest]

I have a report that I need to print duplex automatically when the control to
print the report is clicked. Does anyone know how I can set up the report to
default to duplex?

Thanks!

 

[Jeff Boyce]

Maybe I'm overlooking something, but I was under the impression that duplex
printing is a function of the printer, not the application. Do you have a
duplex printer?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Guest]

Jeff, you are quite correct in assessing that duplex printing is a function
of the printer. However, if Access prepares a multicolumn report and the
user would like a book fold duplex printed report, the way to get it is not a
question of the printer capability. For example the 1st coumn of page 1
would be column 1 of the Access report and the 2nd column would be the last
column of the Access report so that when it is printed on a duplex printer,
the back side would have the 1st column be the 2nd column of the Acccess
report and the 2nd column would be the next to last column of the Access
report. I too have the same request. Is there any easy way to accomplish this
or do I have to go through exporting to Excel and then moving pages around
and then importing from Ecel back to Access?

 

[Guest]

My duplex issue isn't quite as complex as yours, but I think we both need
basically the same answer. I just have a two page report that I would like to
print on only one sheet of paper.

Yes, Jeff, it is a printer capability, and I could request the report to
open and give me the printer properties to select duplex, but I am hoping to
have it do it automatically when the print control is selected.

Thanks!

 

[Guest]

Hi Marella,

I know that this isn't the VBA corner of the community, but if you have a
little experience writing VBA routines you might look into the Printer object
(which was new to Access 2002). I haven't tried it out yet, but the object
has a Duplex property. Just looking at the documentation, it can be set to
one of the following constants:
acPRDPHorizontal
acPRDPSimplex
acPRDPVertical.

Hope that helps.

 

[Guest]

Thank you for the tip. I have Access 2003. I don't have much VBA experience,
just enough to make me dangerous, but I will see what I can figure out.

Thanks again!