question

BobVitter-0872 avatar image
0 Votes"
BobVitter-0872 asked

Unable to set Duplex mode in VBA

The following code does not set the printer to duplex but is does change color mode to B&W
DoCmd.OpenReport Report_Name, acViewDesign, , , acHidden
With Reports(Report_Name).Printer
.Orientation = acPRORPortrait
.ColorMode = acPRCMMonochrome
.Duplex = acPRDPHorizontal
End With
DoCmd.OpenReport Report_Name, acViewPreview

I also tried vbViewPreview in the first OpenReport

and I have tried this on 2 different PCs and printers - both printers support duplex

office-access-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

0 Answers