Results 1 to 7 of 7
  1. #1
    Carmine is offline Novice
    Windows 10 Access 2010 32bit
    Join Date
    Apr 2019
    Posts
    11

    Auto Form Proportionalization

    I’m sure my situation has been addressed a few thousand times. The problem is that when one loads an Access DB developed on a desk top on to a laptop everything appears out of proportion. In fact some of the forms are just too large for the lap top screen. Sadly, unlike Word, Excel, and Power Point, MS has not provided some sort of automatic proportional sizing mechanism. What is the solution to this problem?


    Take Care, and thanks in advance,
    Carmine

  2. #2
    moke123's Avatar
    moke123 is offline Me.Dirty=True
    Windows 11 Office 365
    Join Date
    Oct 2012
    Location
    Ma.
    Posts
    1,879
    If this helped, please click the star * at the bottom left and add to my reputation- Thanks

  3. #3
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    434
    ask the developer to develop another version for the laptop.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,556
    Quote Originally Posted by Carmine View Post
    I’m sure my situation has been addressed a few thousand times. The problem is that when one loads an Access DB developed on a desk top on to a laptop everything appears out of proportion. In fact some of the forms are just too large for the lap top screen. Sadly, unlike Word, Excel, and Power Point, MS has not provided some sort of automatic proportional sizing mechanism. What is the solution to this problem?


    Take Care, and thanks in advance,
    Carmine
    Generally develop on the lowest specification the app is going to run on.
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    When developing a form I temporarily change the monitor resolution to the expected size - typically 1920x1080 but there are laptops out there with smaller resolutions.

  6. #6
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    This feature has been requested for over 25 years!
    Within a few months, Access will finally have the ability for users to zoom forms in / out to handle different monitor sizes / resolutions.

    In the meantime. do look into my automatic form resizing code as already mentioned in post #2
    This will automatically adjust the size and position of forms, form controls and their contents to match individual user screens - scaling down or up as necessary.

    There is absolutely no reason for the developer to spend / waste time creating multiple versions for different users.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  7. #7
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    434
    you already wasted your time creating a form-resizer which is already available on
    the net (VBA). - 1952

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 20
    Last Post: 09-09-2020, 10:31 PM
  2. Replies: 2
    Last Post: 12-29-2016, 11:42 AM
  3. Auto complete & auto add
    By Pete Moss in forum Forms
    Replies: 3
    Last Post: 12-19-2015, 11:40 AM
  4. Replies: 3
    Last Post: 11-04-2011, 01:50 PM
  5. Auto Run Report then Auto Email
    By jo15765 in forum Reports
    Replies: 1
    Last Post: 10-05-2011, 10:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums