Report on a specific printer, bug in access 2007?

[Alain Bourgeois]

Dear all,

in access 2007, I can click the "page setup" menu then the "page setup"
button, and choose to print the report on a specific printer. However,
after saving the report and re-opening it, he still prints on default
printer. The specific printer setting is not saved with the report (this
worked with all previous versions of access, it seems the specific
printer setting has no effect anymore).

Does someone know where I could find a patch or a workaround for this?
(no updates are found through office update, and this might be critical
for some applications).


Regards,
Alain

 

[Allen Browne]

Yes, it's a bug, and AFAIK, there's no fix released yet.

A possible workaround is to assign a custom property to the report to
remember the printer it should go to. Then set the Printer object before
opening the report. Details in:
Printer Selection Utility - Users assign printers to reports
at:
http://allenbrowne.com/AppPrintMgt.html

 

[Alain Bourgeois]

Ok, this helps me to change printer, and this works.

However, the report need to be formatted to print on the default
printer's paper (standard german fanfold), I couldn't do it (through I
have tested with the link present on your page).

Changing it when report is opened in normal mode causes lock error on
table on which report is based.
Changing it when report is opened in design mode shows no error but is
not kept when passing in normal mode.

It you know a solution, this would be nice.

 

[Allen Browne]

Hmm: changing the paper size is more of a challenge.

You may be able to do it with the PaperSize property of the Printer object,
after assigning the Printer, before opening the report.

I can't recall the specifics, but it seems there were problems with that
approach, particularly if the margins were the issue. The alternative would
be to open the report in design view, and set the properties through PrtMip,
but that's quite messy. Here's a starting point if you want to investigate
that:
http://msdn.microsoft.com/archive/d...umControllingYourPrinterinMicrosoftAccess.asp

 

[Alain Bourgeois]

That's totally messy in access 2007: everything I do in design mode in
access 2007 (concerning printer or paper size) is lost when quitting
design mode.