Results 1 to 6 of 6
  1. #1
    Lounger
    Join Date
    Jan 2001
    Location
    Adelaide,SA, Australia
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Reports Opening (Access 2000)

    I want a report to always open at 80% size. I ahve tried setting this and saving and also looked in properties for a settung to do this. Is there a way this can be set

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Reports Opening (Access 2000)

    Could you explain what you mean by 80% size? Do you mean you have the main Access window maximized and you want the report to come up in preview in a specific ratio to that window or what? There isn't any way to set a percentage of size for a report, so I'm at a loss to know what you're setting and saving. I personally prefer my reports to preview maximized so that the user doesn't have to do a lot of scrolling to see a page.
    Charlotte

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Reports Opening (Access 2000)

    If you use the OpenReport method from a form, you can use RunCommand to specify a zoom %. However, you can only ask it for one of the establish ratios; the closest to what you want is 75%. Your code would be:

    DoCmd.OpenReport "yourReport", acViewPreview
    RunCommand acCmdZoom75
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Reports Opening (Access 2000)

    Thanks for jumping in, Mark. That's an argument that I never saw much point in, so I forgot it existed. <img src=/S/crazy.gif border=0 alt=crazy width=15 height=15>
    Charlotte

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Reports Opening (Access 2000)

    I didn't know about it, or had given it much thought, until a client asked for it. At 75%, the report is still readable and doesn't require any left/right scrolling.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Lounger
    Join Date
    Jan 2001
    Location
    Adelaide,SA, Australia
    Posts
    31
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Reports Opening (Access 2000)

    Thank you for your reply. Yes this is what I was trying to achieve. What I did try was to set the ratio to 80% and then save the report again. It would seem then that there is no way of doing this. Thank you for your answer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •