Welcome to SPN

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

Sign Up Now!
  1. Monthly (Recurring) Target: $300 :: Achieved: $95
      Become a Supporter    ::   Make a Contribution   

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---The Ghazi Attack Theatre, Movies & Cinema Tuesday at 1:07 AM
    Ashdoc's Movie Review---Rings Theatre, Movies & Cinema Feb 16, 2017
    Ashdoc's Movie Review---Kaabil Theatre, Movies & Cinema Feb 2, 2017
    Ashdoc's Movie Review---Raees Theatre, Movies & Cinema Jan 26, 2017
    Ashdoc's Movie Review---The Bye Bye Man Theatre, Movies & Cinema Jan 25, 2017

  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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page