Envelopes and Paper Size Issues

  • Thread starter Thread starter Karen
  • Start date Start date
K

Karen

Our application has a report that prints an envelope to
the selected record. I have to go into the report design
and select page setup, change paper size to envelope, and
paper source to manual feed (or envelope feeder, depending
on what printer the workstation uses). The application
resides at each workstation, so I have to do this at each
workstation. Any time I update the application, I have to
repeat this process. Any time the user changes printer
selections, or reinstalls their printer for some reason, I
have to repeat this process.

How can I design our application or our report so that I
don't have to do this?

Thank you.
 
Unless your printing on multiple envelopes at one session,
there shouldn't be any need to change printer paper size settings.

You're printing one envelope at a time.
Let's go with the printer that has an envelope feed slot.
It's probably fed in short side first.
If so, set your envelope report to print in Landscape.
Set it's address controls right at the left of the report.
Then change the margin settings to whatever is needed to
print on the envelope when fed into the slot.
As an example, my printer slot is at the right side of the tray.
To print the address in the approximate middle of
a #10 business envelope I set my margins to:
Left: 3.75"
Top: 2"

That's all.
Let the printer think it's a regular letter. It doesn't matter.
Adjust the margin settings as needed for your layout.
Practice on regular sheets of paper.
Hold it over the envelope to see where it prints.

When ready to use it, place the envelope in the tray, positioned correctly.
Print the report.

You may have to modify this according to your printer and envelope feed
position.
 
This solution does not help because we have many different
printers which call for many different margin settings and
orientations for envelopes, as well as different paper
sources. Therefore we need to use the paper size and paper
source settings on the report File menu. We need one
report design that will work for all printers.
--Karen
 
Karen said:
This solution does not help because we have many different
printers which call for many different margin settings and
orientations for envelopes, as well as different paper
sources. Therefore we need to use the paper size and paper
source settings on the report File menu. We need one
report design that will work for all printers.
Click to expand...

If you're using Access 2002, then you might be able to use
the Printers collection and the Printer object to set these
properties.
 
-----Original Message-----
Karen said:
This solution does not help because we have many different
printers which call for many different margin settings and
orientations for envelopes, as well as different paper
sources. Therefore we need to use the paper size and paper
source settings on the report File menu. We need one
report design that will work for all printers.
Click to expand...

If you're using Access 2002, then you might be able to use
the Printers collection and the Printer object to set these
properties.

--
Marsh
MVP [MS Access]
.
What about Access 97?
Click to expand...
--Karen
 
-----Original Message-----
The Printer object is new in A2002. Nothing comparable in
A97.

As a last straw grasping suggestion, you might try searcing
the web and the Google newsgroups archives to see if anyone
has come up with an API utility that does these things.
 
Back
Top