Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Zoom View in Access

Discussion in 'Information Technology' started by Kimby@Ecology, Jul 28, 2006.

Tags:
  1. Kimby@Ecology

    Kimby@Ecology
    Expand Collapse
    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
     
  2. Loading...

    Similar Threads Forum Date
    Ashdoc's Movie Review---Force 2 Theatre, Movies & Cinema Nov 20, 2016
    Ashdoc's Movie Review---Rock On 2 Theatre, Movies & Cinema Nov 13, 2016
    Movies Alternate View - Review Of 'PROMETHEUS' Theatre, Movies & Cinema Nov 12, 2016
    Ashdoc's Movie Review---Mr Church Theatre, Movies & Cinema Nov 5, 2016
    Ashdoc's Movie Review---Ae Dil Hain Mushkil Theatre, Movies & Cinema Nov 1, 2016

  3. kabaka

    kabaka
    Expand Collapse
    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



    "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/com...-91d4-74fdbc57cc38&dg=microsoft.public.access
     
  4. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    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" <KimbyEcology@discussions.microsoft.com> 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
    > 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
     
  5. Kimby@Ecology

    Kimby@Ecology
    Expand Collapse
    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
     

Share This Page