Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Resize report (Access 2000)

    I am trying to re-size a report, which I open from within a module.

    When it opens, it opens at 100%, whereas I want it to open as Size to Fit.

    Any suggestions as to how I set this.



    Thanks


    Colin McDonald
    colinmac@blueyonder.co.uk

  2. #2
    4 Star Lounger SteveH's Avatar
    Join Date
    Jan 2001
    Location
    Chelsea, Gtr London, United Kingdom
    Posts
    587
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resize report (Access 2000)

    Try this link to Dev Ashish's excellent site
    <A target="_blank" HREF=http://www.mvps.org/access/reports/rpt0020.htm>http://www.mvps.org/access/reports/rpt0020.htm</A>
    Steve H
    IT Lecturer/Access Developer
    O2K SR3/O2010; Win7Pro

  3. #3
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resize report (Access 2000)

    Steve Thanks. It looks to be what i want.

    I've tried it, and placed the function in a module on its own, then called it using

    PreviewAndZoomReport("MyReport",0)

    I get a complie error saying Expected =

    Is this misisng references?

    or something else



    Colin

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

    Re: Resize report (Access 2000)

    No, it's a syntax error.

    Either take out the parens like this:

    PreviewAndZoomReport "MyReport",0

    or use the Call keyword like this:

    Call PreviewAndZoomReport("MyReport",0)

    or assign the result to a variable like this:

    MyVariable = PreviewAndZoomReport("MyReport",0)
    Charlotte

  5. #5
    4 Star Lounger
    Join Date
    Jun 2001
    Location
    Edinburgh, Midlothian, Scotland
    Posts
    492
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Resize report (Access 2000)

    Charlotte

    That was easy wasn't it?

    I simply cannot get my head around syntax I'm afraid.

    Thanks for your help.


    Colin

Posting Permissions

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