Set Paper Size

  • Thread starter Thread starter NevilleT
  • Start date Start date
N

NevilleT

I want to set paper size (Letter or A4) using a stored parameter. The file
is an MDE file and I need to cater for Access 2000 to 2007. Can it be done
using VBA? I have seen examples using MDB files where you go to design view
and save the paper size but not using MDE
 
Because you cannot go into design view in an MDE, I don't believe you can
change the paper size property.
 
Alex,

I've been trying to resolve a similar issue -- using 2000RT.

The default paper size (Legal or 11x17) is being saved in my report file,
Name AutoCorrect is not turned on, but the report still responds as Letter,
whether previewed, printed, or output to Snapshot.

Your reply seems to indicate that you can indeed have a non-letter size
report -- is there some secret to making this work?
 
I just made a new report, based on, say, MyReport, set it paper size to
Letter, and then save it as MyReportLetter, so if user need to print on
letter size paper - then I open this report instead of default one

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com
 
Alex,

Having/selecting the desired version of the report isn't the problem --
what's frustrating me is that all my non-Letter size reports always format as
Letter!!!
 
Hi Alex.

All my reports are set to use the default printer. I have tried changing my
default printer to different options with the same effect -- the report
defaults to Letter. For a Legal or 11x17 size report, each page is split
into multiple 8-1/2 x 11 pages. If I am previewing, if I go into Page Setup,
the paper size says Letter (even though in design view the size is saved
correctly). I can change to the "correct" paper size and the preview
regenerates properly. But obviously, this isn't an option if I want to go
directly to the printer or a Snapshot file without previewing.

Any idea?
 
It's definitely an issue with the runtime.

If I open your mdb in 2003 and preview your reports, they display in the
correct size. However, if I open them using the 2000RT, they all are Letter!

(I have already verified this in my own app -- in the fe mdb, they do open
in the saved paper size, but not in the RT.)
 
Back
Top