none
Standard Size for Main Access Form RRS feed

  • Question

  • I am creating an access app for someone where it will be one main "container" form and in it will have a menu and the action forms. Is there a standard main form size that fits most monitor sizes and resolutions?  These are mostly 24"monitors at 1920/1080 resolution.

    I will be auto centering the main form on load, but I really cant make the forms adjust on resize. It has to be a standard that fits best

    Wednesday, October 23, 2019 9:38 PM

Answers

All replies

  • There is no standard size. "Mostly" won't cut it.

    Sometimes you know the resolutions (including Zoom levels nowadays) of your users, and you can work with that.

    Sometimes you can use the tabbed interface, so all forms are full size and will have scrollbars if needed, just like web pages.

    You can do SOME resizing utilizing Horizontal and Vertical Anchor properties.


    -Tom. Microsoft Access MVP

    Wednesday, October 23, 2019 10:01 PM
  • Review http://www.devhut.net/2017/09/08/access-form-resizing-based-on-screen-resolution/ hopefully it will help you as it offers numerous solutions to this issue.

    Daniel Pineault, 2010-2019 Microsoft MVP
    Professional Support: http://www.cardaconsultants.com
    MS Access Tips and Code Samples: http://www.devhut.net


    Wednesday, October 23, 2019 11:25 PM
  • there are so many forms of PC/screens out in the world that best practices is to have scrolling enabled in both directions.  generally you'll never get people to reset their resolution for any one Access app. 

    It does make sense to fit the design to what will be the overwhelming majority of screens - but beyond that it's a wild world....

    .....then the traveling laptop user complains that they have to scroll too much due to their smaller screen...  but hey....

    Thursday, October 24, 2019 9:59 PM
  • The solutions proposed around dynamic resizing is surely the best but from my experience the lowest resolution you should expect it should be 1280x800 ...compared to other resolution might seems too small (FHD,4K) but it should be enough for about everyone to work.
    Friday, October 25, 2019 5:57 AM
  • As others have said, the range of monitor sizes and resolutions in existence makes a one size fits all solution impossible.

    In my opinion, the solution is to use automatic form resizing. See my detailed tutorial on this topic  http://www.mendipdatasystems.co.uk/automatic-form-resizing-1/4594554784

    This includes an example app with all code required to use the feature

    Saturday, October 26, 2019 10:26 AM