Results 1 to 8 of 8
  1. #1
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167

    Unanswered: Automatic Form Scale Adjustment?

    Is there a setting in a form or a module somewhere that automatically resizes forms to be the same dimmensions despite the screen resolution or apect ratio? My form looks great on 800 x 600 but I can barely read it when I open on my monitor at home which is widescreen and set at higher resolution. It's kind of frustrating to spend that much time on something, only to have it look nothing like you designed it to look. Thank you, Joshua

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Is there a setting in a form or a module somewhere that automatically resizes forms to be the same dimmensions despite the screen resolution or apect ratio?
    No.

    .......
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    You'll need a hack for this, and fortunately someone has already done the work for you! Go to this site and scroll down to the "Access Form Resizer" and download it. I've used it before without problems, and best of all, it's FREE!

    Jamie's Software - Image Database Software, Microsoft Access Freeware & MS Access Articles & Tutorials

    Notice that it works best when the app is developed in the lowest needed resolution and the form resized up, such as yours will be.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Why is it an executable and not a zip/MDB? What all is it installing besides the database? Is it installing references on my registry? Just want to make sure before I mess with it. Thanks, Joshua

  5. #5
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    I found on downloads.com so I trusted and ran. It extracted an MDB and help file to the destination I specified. I opened the database and after clicking on an agreement, it exported a module to the Access database I specified. I then went into my database and added a single line of code to the 'On Load' event for the form and it is resizing correctly. I was worried that my database would be calling a function from this database but I guess it is self-contained. I deleted the database the module was exported from and the form resize is still working great. Thanks for pointing me to this! I really appreciate it! Joshua

  6. #6
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Glad you got it working! There are a number of these around but this particular one has been out there for quite a while and I've never had any problems with it. The only problems I've read about involve users ignoring the caveat that it works best in upsizing forms, where the db is developed in the lowest target resolution then upsized to higher resolutions.

    Good luck with your project.

    Linq
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  7. #7
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    There's a form re-sizing example in the code-bank.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  8. #8
    Join Date
    Jan 2009
    Location
    Ohio, United States
    Posts
    167
    Ok, this might be a different problem. I put the database on my brother's computer (Vista, Access 2007) and it did scale up the forms. However, it seems like Access 2007 is having trouble identifying the borders, even when I removed the OnLoad resize module. When I opened a form, it made it much wider than it should have been. I changed the formatting and got it to look ok in form view but after I saved and reopened, it was formatted the same incorrect way. I tried messing with every possible combination of the resize, auto center,... properties but I could not get the borders to act in a predictable way. Has anyone else experienced this? How did you resolve it?

Posting Permissions

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