Setting paper sizes for Access XP Reports



I have an Access XP database with two reports. One Report is to fit on Letter
size paper and the other on Legal size. I know I can change the paper size
from the file menu, but I'd like to be able to set the paper size within the
report so that the user doesn't have to go through the bother of resetting it
when going between reports. The help menu mentions something about PaperSize
Member, but its unclear how one might set that parameter. Any ideas, or am I
simply up a creek without a paddle?



Allen Browne

If this database is for your own use, you can open the report in design
view, choose Page Setup from the File menu, and set the report to a specific
printer. It should now remember the specific paper size and orientation for
that report.

The Printer object (in Access 2002 and later) does have a PaperSize property
which can be set to one of the members of the acPrintPaperSize constants.
(For values, press F2 in the code window to open the Object browser.) But
you need to experiment with this, as the report's Width, marigns, and
orientation are all invovled in how this works, and I'm not sure it all
works as you would expect.

The other alternative is set the values of the members of PrtMip. This is a
bit of a dog's breakfast, and needs to be done in report design so is not
suitable if your database will ever need to be an MDE. If you are interested
in following this through, here's an introduction:

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question