Set Paper Size

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
 
D

Douglas J. Steele

Because you cannot go into design view in an MDE, I don't believe you can
change the paper size property.
 
T

terri

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?
 
A

Alex Dybenko

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
 
T

terri

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!!!
 
T

terri

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?
 
T

terri

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.)
 

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

Similar Threads

Setting default paper size 2
PowerPoint Printing PPT to PDF without losing quality 1
Windows XP Custom Paper Size in Win Xp 1
Using the selected paper size for the next printing 1
How to make the report previewed in the right paper size ? 2
Syntax to set Startup Properties from code 3
Paper size is saved on the last page setup 7
Change default paper size to A4 for all users 5

Top