fit to screen

[Sarah]

Hi, I am a new user trying to make my report fit to the screen. I have a
multi report that i have dragged four different reports to make one report.
My problem is i know that i have alot of information going on with this
report, but i would like it to print on one page. Could you please advise of
what the vba code is for this to print one page and shrink the information
for this to fit? Thanks Sarah

 

[Douglas J. Steele]

Sorry, but there's no "fit to one page" option in Access.

 

[Arvin Meyer [MVP]]

As Doug mentioned, this is not built into Access. I use Clickbook for
specialty printing, and I believe it will do exactly what you are after.
Have a look at their website:

http://www.bluesquirrel.com

--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

Disclaimer: Any code or opinions are offered here as is. Some of that
code has been well tested for number of years. Some of it is untested
"aircode" typed directly into the post. Some may be code from other
authors. Some of the products recommended have been purchased and
used by the author. Others have been furnished by their manufacturers.
Still others have not been personally tested, but have been
recommended by others whom this author respects.

You can thank the FTC of the USA for making this disclaimer necessary.

 

[Fred]

The usual practice is:

For horizontal fit: The report has a fixed design width. Design the report
so that the width is your desired width (presumably that of one page of the
paper that you are using)

The vertical size varies dramatically with the amount of records that you
are going to print. For example, just by changing a query condition, you can
make it vary from a 1 page of data to 100 pages of data. I'm no expert in
that area, but I have a hard time imagining the availability a "VBA code" to
make all of those scenarios fit onto one page.