Print legal size

[ktk]

I am trying to automate my reports so if they are legal
size reports they will print legal size. I don't want my
users to have to reset the page size each and every time
they print the report.

In Microsoft Knowledgebase it gives a module that will put
the report in design mode and change the page setting to
legal size. This work great if using access .mdb file but
it does not work if you are using an .mde file. An .mde
file can not go in design mode of a report.

I am using Access 2000.

Can anyone help?

There needs to be a properies setting in the report for
pagesize!! Many others have complained about this problem
and even the the newest version of Access seems to have
this same anoying problem. Is there anyway to let
Microsoft know of this issue so hopefully they can add a
feature that will fix this problem?

I am very frustrated. The only reason I don't use an .mde
file and have my programs secure is because of this
issue. There needs to be a work around for this!

 

[SA]

Ktk:

1.) You are correct that you can't change a report's paper size at run time
in an mde. Just no way to do it.
2.) With Access 2000, make sure that you've installed the Service release
1-3 which resolve some basic issues with reports not retaining layout and
paper specs when printed.
3.) The last issue is that normally when a report is previewed and the user
changes printers, the report will "pickup" or load, when the printer is
switched, the default paper size and layout of the newly selected printer.
The solution here is usually to not let user's change printers in preview
mode. But to only allow printer switching by changing the default printer
for the system and then sending the report to print.
4.) In some instances that may still not work if the "form name" of the
paper size is different from one printer to the next, again causing the
report to revert to the target printer's default settings. The only way
round is to set the target printer's default paper size and layout to match
your report's specifications before you send the report to print.

If item 3 and/or 4 are of interest, you might look at our "On the Fly
Printing" classes for Access. The offer the capabilites to present the user
with a print dialog while the report is closed so they can choose their
printer an send the report out using its default settings; secondly the code
provides a method to adjust a target printer's default paper size and layout
before sending the report to print so that the printer "matches" your
reports specifications thereby eliminating any reversion to a default paper
size / layout of the printer when the report is sent to print. You'll find
it on our web.