Setting Application.Printer.Duplex Not Working.

[Ed2020]

Hi,

I have been having some problems with Access 2003 not printing reports double-sided, even if the printer's default is to print duplex.

I have found a couple of solutions to this:

1. Set the report's .Printer.Duplex property each time the report is printed:

Public Sub PrintReport(ByVal strReportName As String)
    DoCmd.OpenReport strReportName, acViewPreview
    
    With Reports(strReportName).Printer
         .Duplex = acPRDPVertical
    End With
    
    DoCmd.PrintOut
    
    DoCmd.Close acReport, strReportName
End Sub

2. Set the applications .Printer.Duplex property on startup of the database:

Application.Printer.Duplex = acPRDPVertical

My preferred option is number 2 as this means I don't have to trawl through the whole system amending all code that prints a report. Although the application property change runs it doesn't appear to work when printing the reports.

Could anyone shed any light on why this doesn't work please?

Many thanks,

Ed Metcalfe.

Please do not feed the trolls.....