Share via

Unable to set Duplex mode in VBA

Bob Vitter 181 Reputation points
2021-05-24T14:34:01.857+00:00

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

Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
881 questions
0 comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.