Printing Double-Sided

DreamGenius · May 12, 2009

I have a bunch of reports, all of which render correctly. One of them prints per the default Printing Preferences configured on my machine but the others do not; they override the settings.

Is there some hidden setting in report design that I haven't found yet which causes this? Interested, frustrated minds equally await the wisdom of this forum.

Alc · May 12, 2009

Is this link any use?

http://msdn.microsoft.com/en-us/library/aa173220(office.11).aspx

DreamGenius · May 12, 2009

Well, it was tad more complicated than I was looking for really. It did however set me off searching for something similar, which lead to this link. From that, I was able to develop the following code snippet, which appears to deliver what I was looking for:

Code:

DoCmd.OpenReport strReport, acPreview   ' This piece of code already existed
 
Dim rptReport As Report
Set rptReport = Reports(strReport)
 
If rptReport.Printer.Orientation = acPRORLandscape Then
    rptReport.Printer.Duplex = acPRDPVertical
Else
    rptReport.Printer.Duplex = acPRDPHorizontal
End If

This not only forces duplex printing but also forces the flip to be correct, based on the orientation setting of the report.

The answer to my original question appears to be that I wasn't missing anything, but you can do so much with VBA, so thank you!

Alc · May 12, 2009

Good to hear you got it working.

Printing Double-Sided

DreamGenius

Annoying Questionner

Alc

Registered User.

DreamGenius

Annoying Questionner

Alc

Registered User.

Similar threads

Users who are viewing this thread