Access ignoring default printer settings

Question

I have several Access programs, they're fairly complex, lots of VBA in them and dozens of reports, linked tables, etc. When I print these reports, they don't respect my default printer settings (namely, the duplex option). How can I correct this?

Solution

you need to set the .UseDefaultPrinter property of the report to True.

From here, this code will reset the printer of all reports to default:

For Each obj In CurrentProject.AllReports
    DoCmd.OpenReport ReportName:=obj.Name, View:=acViewDesign
    If Not Reports(obj.Name).UseDefaultPrinter Then
        Reports(obj.Name).UseDefaultPrinter = True
        DoCmd.Save ObjectType:=acReport, ObjectName:=obj.Name
    End If
    DoCmd.Close
Next obj

Comments

[MAW74656]

Where should I put this code? In autoexec?

[SeanC]

it can be put into autoexec, or as a separate piece of code that can be run at anytime.