Report Width

[Kevin D.]

How can I change the width of a report using code before the report opens?
For instance, if a report has a physical width of 5 inches and I want to
change the width to 7 inches if certain conditions are met before the report
is opened.

Thanks,

Kevin

 

[Allen Browne]

In Report_Open, you can set the Left and Width properties of the controls so
they appear where you want them.

You cannot easily modify the width of the report. That is defined by by the
paper width less the left and right margins. It is therefore affected by
factors such as:
a) the printer (what width paper it uses)
b) the orientation of the report (landscape or portrait)
c) its unprintable area
d) whether the report was saved for a particular printer/paper/orientation.

If you are developing for other users, they may have a completely different
paper/printer than you do.

It is possible to open the report in design view, and modify some of these
properties using PrtMIP etc. If you do this, you are destroying your chances
of creating an MDE.

Access 2002 and later have a Printer property, but I have not found that to
be a useful way to modify paper size.