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

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alain Bourgeois" <brils...@skynet.be> wrote in message
news:466DD38A...@skynet.be...

[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/default.asp?url=/archive/en-us/dnaraccessdev/html/ODC_MicrosoftOfficeDeveloperForumControllingYourPrinterinMicrosoftAccess.asp

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Alain Bourgeois" <brils...@skynet.be> wrote in message

news:46784340...@skynet.be...

> 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 wrote:
>>
>> 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]

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.