If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
fit to screen
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 |
#2
|
|||
|
|||
fit to screen
Sorry, but there's no "fit to one page" option in Access.
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Sarah" wrote in message ... 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 |
#3
|
|||
|
|||
fit to screen
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. "Sarah" wrote in message ... 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 |
#4
|
|||
|
|||
fit to screen
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. |
Thread Tools | |
Display Modes | |
|
|