Printing options

[Luke Bellamy]

Hi - I currently use the Application.Printer object to set things like
margins
and print quality. An office has a printer with 1 tray as A4 and another as
Letterhead paper size.
They have found that when printing and the A4 runs out it Access will use
the letterhead (not desired).
Even though there are many different trays can I set the paper size on the
Printer object and it
will only use the single tray that contains the matching paper size?

Thankyou,
Luke Bellamy

 

[Joseph Meehan]

Hi - I currently use the Application.Printer object to set things like
margins
and print quality. An office has a printer with 1 tray as A4 and another
as
Letterhead paper size.
They have found that when printing and the A4 runs out it Access will use
the letterhead (not desired).
Even though there are many different trays can I set the paper size on the
Printer object and it
will only use the single tray that contains the matching paper size?

Thankyou,
Luke Bellamy

It has been my experience that, at least in some cases, this is a setup
in firm wear at the printer. It may not be possible to take care of it with
Access. Check the printer manual and see if you can find an answer.

It may well turn into a problem in a typical business environment where
printers are shared, as someone else always seems to want those kind of
settings the other way around from whatever you need.