Access 2007 FAQ
How do you assign a report to a specific printer in Access 2007 and have it remember that setting? The next time I open the report, Access forgets that I assigned it to a specific printer.
Access 2007, like previous versions, allows you to assign a report to print to a specific printer. With the report in Design View you can open the Page Setup dialog box, select Use Specific Printer, click the Printer button, and then select a specific printer, as seen in the following screenshot.
However, the next time you open the report, Access forgets this setting and reverts back to the Default Printer setting. This is a known bug in the release version of Access 2007. Microsoft is looking into this issue.
Access MVP Allen Browne has a workaround for this issue on the following page:
http://allenbrowne.com/AppPrintMgt.html
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page