Results 1 to 7 of 7
  1. #1
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    280

    Maximum size of forms on 4k Monitors

    I am currently using a 24 inch FHD Monitor.


    The maximum height and width of any single form is defined to be about 22.75 inches - which is determined by the maximum integer size of 32767 divided by 1440 (TWIPs per inch).
    So some of my forms fill the full width of the screen nicely.
    I have tried a QHD monitor and the width of forms is now much less that 22.75 (when at default monitor resolution). Presumably a 4K Monitor would result in even narrower maximum form width. Is this assumption correct?

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    The actual limit is a little bit less than 32767 as there are approx 15 twips to a pixel, 96 pixels to an inch. So depends on the number of pixels to an inch. With higher resolution monitors there may be more pixels to an inch so will appear smaller

  3. #3
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    280
    Thanks for the reply. Yes, this is the problem. I am wondering if many people use Access on 4K monitors, as the form size will be very restricted unless they are using some sort of scaling, which would seem to defeat the purpose of having a high definition monitor. Can't believe that Microsoft have not addressed this issue yet, by replacing the Integer definition to Long Integer for what ever holds the form width and height.
    Unless I am mistaken, with a 4K monitor, there are about 192 pixels per inch (for typical 24 inch monitor), so form width and height would be limited to about 11 inches.

  4. #4
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    I have a wide screen monitor (resolution 3440 x 1440) and that works fine at 100% scale. Only issue I have is when sharing on zoom/teams/whatever I change the resolution to 1920 X 1080 otherwise the other participants struggle to see my presentation!

    My laptop is 1920 x 1080, but I have to set the scaling to 150% to make it easily readable - not just Access but any app.

    1920 x 1080 is a common resolution - but the maximum form width that will support is 20" at 'full screen' at 100% scaling (28800 twips) - at least for my laptop, other monitors may be larger or smaller for the same resolution

    You might find this article by @isladogs of interest

    https://isladogs.co.uk/automatic-for...g-1/index.html

  5. #5
    Minty is offline VIP
    Windows 10 Office 365
    Join Date
    Sep 2017
    Location
    UK - Wiltshire
    Posts
    3,157
    I believe that larger monitor support is slated in to the Access future developments for next year, but don't hold your breath.
    DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
    Please use the star below the post to say thanks if we have helped !
    ↓↓ It's down here ↓↓

  6. #6
    Miles R is offline Competent Performer
    Windows 10 Office 365
    Join Date
    Mar 2019
    Posts
    280
    Thanks for the replies. I look forward to large monitor support if it ever arrives. Only then would I consider a larger 4K monitor as I make heavy use of Access databases (that have taken years to develop), integrating back end and front end with links to images and documents on my desktop computer. Not sure if there is any desktop application out there that is half as good as Access. A web based system would be no good for my purposes.
    I am sure others will take a different view.

    Moving from 32 bit Windows 10 Access to 64 bit Windows 11 Access caused me to make a few changes as the Quick Access Menu bar is taller, forcing some things do disappear of the bottom of forms. These needed adjustment. Also, I notice the scroll bars are slightly different. No big deal though.

  7. #7
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,932
    Only then would I consider a larger 4K monitor as I make heavy use of Access databases
    if you are developing for yourself, that is fine. But if developing for others, you need to design for the smallest monitor - these days typically 1920 x 1080.

    Be aware that some monitors can be 'split' - I can split mine vertically into two 'windows', but there are others out there that can split into 4 or more and different sizes if they are large enough. And there are gadgets out there that can do the same. Benefit over multiple monitors is the monitor bezel doesn't get in the way when a form goes over multiple screens.

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

Similar Threads

  1. Form pop-up on dual monitors
    By templeowls in forum Programming
    Replies: 2
    Last Post: 08-16-2022, 04:43 PM
  2. Replies: 5
    Last Post: 02-25-2022, 09:37 AM
  3. Replies: 12
    Last Post: 01-27-2017, 09:10 AM
  4. Replies: 2
    Last Post: 10-18-2016, 07:07 AM
  5. Replies: 4
    Last Post: 03-04-2015, 03:23 PM

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