Zoom View in Access

#1 (**permalink**) 28-Jul-2006, 08:24 AM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11866-zoom-view-in-access.html
my monitor settings. Mimicking the way it works in Excel would be great.
Ctrl+Scroll Wheel on the mouse works fantastic. Thanks!

----------------
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866
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/comm....public.access

#2 (**permalink**) 28-Jul-2006, 08:24 AM

You can. Use either

1)Reports![YourReportName].ZoomControl = 125
or
2)DoCmd.RunCommand acCmdZoom100
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866

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

DoCmd.OpenReport "YourReportName", acViewPreview
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866
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

"Kimby@Ecology" wrote:

> 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/comm....public.access

#3 (**permalink**) 28-Jul-2006, 08:24 AM

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

"Kimby@Ecology" wrote in message
news:3EB038C7-17D3-4A89-91D4-74FDBC57CC38@microsoft.com...
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866
> 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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866
> 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/comm....public.access

#4 (**permalink**) 28-Jul-2006, 08:25 AM

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.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866
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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11866
whether I'm wearing my glasses at the moment) I can quickly and easily adjust
the zoom to meet my needs.

Thanks!

Kimby