Saving Report Print Settings in Access 2007

[Pdrwa]

I've upgraded to Office 2007. I have several reports that I want to print
using a certain printer, 2 sided and hole punched. I've used Page Setup to
select the printer and properties I want. However, Access doesn't save my
settings. According to the Help section, it should save the settings. What
am I doing wrong?

 

[Allen Browne]

Yes, this is a bug in Access 2007. Microsoft has not promised, but we are
hoping it is fixed when SP1 is released.

In the mean time, I'm not aware of a solution, but is is possible to achieve
the same effect by setting the Printer object to the right printer before
opening the report.

Here's an example of the code to create a custom property for the report,
assign the printer, and deassign it again afterward:
Printer Selection Utility
at:
http://allenbrowne.com/AppPrintMgt.html

 

[Pdrwa]

Thank you Allen. I'll try out your code and hope Microsoft chooses to fix
this.