Printing Envelopes

[Shadow]

I have a form that sets up an #10 envelope for printing.
I can set the printer to print the #10 envelope but the
next time I print an envelop it comes out letter size. The
printer will not remember my default setting to '#10
envelope' for this form.

What statement can I put in my 'Print Envelope' VBA
proceedure to force the printer to use a #10 envelope
setting?

Shadow

 

[Gary Miller]

Shadow,

I am assuming that your envelope is in reality a report that
your code is calling. Try setting the paper size from
File/PageSetup when you have this report open in DesignView,
not Preview. Do a save and it should retain the setting.

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________

 

[Shadow]

Gary
It is really a form the size of a #10 envelope with 2
control buttons that permit searching the database for the
envelope address by the owner name or the property
address. The found address is placed on the envelope form
in the normal address location. A third control button
prints the envelope.

Printing works for while but sometimes slips back
to 'letter' when the database program is reopened. I will
retry your solution on a two of computers that seem
especially bad at slipping back and that use the envelope
printing feature the most. These two computers have the
same default HP LJ 2100 printer.

I know my computer is set to envelope in the form design
mode and I do not have this problem. The program on the
network is also set to envelope in the design mode of the
form.

Shadow

 

[Gary Miller]

Shadow,

The key deal here is to choose the paper size in design and
then save before closing while still in design.

Good Luck,

--

Gary Miller
Gary Miller Computer Services
Sisters, OR
________________________