Zoom View in Access

[Guest]

It would be very helpful to be able to change the zoom view in Access. For
example, I have a report designed to print perfectly on one page. However,
because I have a nice, new, large monitor, the screen entry for that report
only takes up about 2/3 of the available space on the screen.

It would be helpful if I could simply zoom in and make the display on the
screen larger without having to either (1) redesign my report, or (2) change
my monitor settings. Mimicking the way it works in Excel would be great.
Ctrl+Scroll Wheel on the mouse works fantastic. Thanks!

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...-91d4-74fdbc57cc38&dg=microsoft.public.access

 

[Guest]

You can. Use either

1)Reports![YourReportName].ZoomControl = 125
or
2)DoCmd.RunCommand acCmdZoom100

right after you open your report in code. For example:

DoCmd.OpenReport "YourReportName", acViewPreview
DoCmd.RunCommand acCmdZoom100

Note that in 1) you can replace 125 with any number, but in 2) it must be
10,25,50,75,100,150 or 200

 

[Arvin Meyer [MVP]]

You might try a bit of code like this called from the report's Open event:

Sub Report_Open(Cancel As Integer)
DoCmd.OpenReport "rptReportName", acViewPreview
DoCmd.Maximize
DoCmd.RunCommand acCmdFitToWindow
End Sub
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks for the great suggestions. What I meant to suggest is a method of
changing the zoom level as needed or desired without resorting to code.
Since every other program in Office uses the Ctrl+Scroll feature, it seems
Access should as well. That way, (regardless of what monitor I'm using or
whether I'm wearing my glasses at the moment) I can quickly and easily adjust
the zoom to meet my needs.

Thanks!

Kimby