Printing Double-Sided (1 Viewer)

DreamGenius

Annoying Questionner
Local time
Today, 04:29
Joined
Jul 29, 2004
Messages
116
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.
 

DreamGenius

Annoying Questionner
Local time
Today, 04:29
Joined
Jul 29, 2004
Messages
116
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!
 
Last edited:

Alc

Registered User.
Local time
Yesterday, 23:29
Joined
Mar 23, 2007
Messages
2,386
Good to hear you got it working.
 

Users who are viewing this thread

Top Bottom