VBA‎ > ‎

VBA to turn duplex printing on or off from Access

If your printer supports duplex printing, this VBA code will turn off or on duplex printing from within an Access database.
 
To turn duplex printing on:
 
    Dim prt As Printer
    Set prt = Application.Printer
    With prt
        .Duplex = acPRDPVertical
    End With
 
To turn duplex printing off:
 
    Dim prt As Printer
    Set prt = Application.Printer
    With prt
        .Duplex = acPRDPSimplex
    End With
Comments