Results 1 to 6 of 6
  1. #1
    JohnSparrow is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2023
    Posts
    1

    How to fit the form to the notebook screen?

    Hello, dear colleagues.



    I connected to Access app the notebook with 11' diagonal (1920*1080 / Windows 10 / Office 365). But Access app forms doesn't fit to the notebook's screen, scroll bars appeared & working with forms is very inconvenient.

    Access app was developed on a PC with 23' monitor (1920*1080 / Windows 10 / Office 365). Because of a lot of controls in the forms (as well as lot of columns in the corresponding LisBoxes & large wide of these ListBoxes) the forms were designed to fit to a screen (to cover the whole accessible screen space when Access window in expanded state). There are no problems with users PCs with 23' - 24' monitors (1920*1080 / Windows 10 / Ms Office 2013-2019), all the forms fits the screens.

    I have change the DPI settings for MSACCESS.EXE using this instruction, but without any visible changes in result.

    Could you please give any advise about this problem?

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,938
    You could try isladogs Form Resize code? Generally you would develop for the smallest screen, not the other way around?
    https://isladogs.co.uk/automatic-for...g-1/index.html
    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

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    There are several resizing hacks out there, but as Welshgasman suggested, these all work best when sizing UP, meaning you need to start out with a 'smaller' screen, if you will. But this kind of problem is always associated with the resolution of the screen, not the screen size.

    This is confusing, as you state in your OP that the resolution on all machines is 1920*1080...are you sure that this is true on the notebook?

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

    All posts/responses based on Access 2003/2007

  4. #4
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    My 12 inch Windows tablet has a resolution of 1920*1080 with 125% scaling factor
    Using my automatic form resizing (AFR) code, I can run any app on a range of monitors from the tablet up to 38 inch widescreen UHD monitors

    @missingglinq
    Good to see you after a long gap. However, I certainly wouldn't call the use of AFR a 'hack'
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  5. #5
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    Before 'hack' got a bad name, mainly in the main stream media, in the pre-Windows days, it used to be used as a term of respect for any particularly clever procedure!
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  6. #6
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,977
    Ha! You must be referring to prehistoric days when we were both very young and the world was much more innocent than today
    Colin, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

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

Similar Threads

  1. Form on top of screen
    By Joakim N in forum Programming
    Replies: 9
    Last Post: 04-01-2017, 12:44 PM
  2. Replies: 12
    Last Post: 03-01-2017, 10:39 PM
  3. Best screen resultion for most common screen sizes
    By sjs94704 in forum Database Design
    Replies: 3
    Last Post: 05-26-2015, 06:12 AM
  4. bar on form screen
    By everette in forum Access
    Replies: 2
    Last Post: 10-08-2011, 12:10 PM
  5. Replies: 11
    Last Post: 06-05-2011, 09:51 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