Print report to 11x17 output


Dale Fye

I've got a couple of reports that were formatted for a standard 8 1/2 by 11
paper. Now, my client wants to print these same reports to 11 by 17.

I know I could reformat the entire report for 11 by 17, but would prefer to
figure out some setting in the print dialog that would modify the report
output to fit in whatever size page I have selected (whether it be an
envelope, 11x17 or 14x20).

Anybody have any experience with this?

Larry Linson

Access' print setup, unlike some other Microsoft Office software, does not
have a "fit to page" option. On the other hand, all that does is enlarge or
shrink the existing page; and, that is not what I think of when I think of
an 11X17 report. Did you discuss just what the client meant when he said he
wanted the 8.5 x 11 report now printed at 11 x 17?

Access reporting would have to be incredibly smart to know what data you
would want printed where, and what additional data you'd want added in the
blank spaces, if you were following what I'd imagine.

Larry Linson
Microsoft Office Access MVP

Dale Fye


All he wants to do is blow the report up (150% or so) so he can post it on
the wall in our his office and conference room.



A couple of work-around ideas (just short of using "enlarge" on an 11 x 17
copy machine :) )

- User printer software/driver/settings (if in there for that printer) to
set the paper size to 11 x 17 and "fit to page" setting

- Same as above using a pdf-maker "printer" and then print the pdf.

Dale Fye


I thought about the copier, but I was trying to be creative, and learn
something new.

What I'm doing now is using:

With rpt
docmd.RunCommand acCmdPrint
end with

to open up a print dialog box, unfortunately, I have worked my way through
about 15 different combinations of options, and cannot seem to find the one
that will actually size the output to fit the page. I'm looking through the
Access Developers Handbook, and will try testing the DevMode settings later
today or tomorrow.

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