Results 1 to 5 of 5
  1. #1
    TonyM is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020

    Coding for users with different screen sizes

    This question relates to an Excel VBA project but is general enough hopefully to apply to Access as well. I need to make the project available to different users who have different computer screen sizes : everything from a tablet to a full size laptop. The project has several forms. I will probably make the project available through One Drive or perhaps DropBox. How can I assure that the forms will adjust to the various screen sizes much like what seems to automatically happen with web pages displayed on different screens? Thanks in advance for any replies.

  2. #2
    Micron is online now Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Ontario, Canada
    If isladogs sees this, he will likely point you to his resizing utility. I looked but could not find it. You could try his contact form there too.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Richmond (Virginia, not North Yorkshire!)
    Here's the link @Micron mentioned:

    Linq ;0)>
    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Somerset, UK
    I've just seen this thread. Many thanks to @Micron and @missinglinq for alerting me.
    Rather than use the AWF link, I suggest you go directly to my three part website article on Automatic Form Resizing (AFR):
    The article includes a demo app and all code required to use AFR
    Although the code involved is fairly complex, as a developer you just need to import a module modResizeForm and add one line of code ResizeForm Me to the Form_Load event of each form you want to be resized. You can use it without understanding it fully. For the end user, all resize/reposition changes occur automatically.

    The only other real issue to consider is that the 'base resolution' used for form design should be no higher than the lowest resolution of your end users.
    That is because the code works very well when 'scaling up' but less well if you try to 'scale down'

    1. As a side note, when you referred to making the project available via OneDrive/Dropbox, I hope you were just talking about distribution methods.
    Whilst that is a perfectly good approach for distribution, neither of those are suitable for users to run Access databases from.
    Trying to do so risks database corruption whenever there is a network interruption ...which WILL happen.

    2. Re-reading your post. you started by mentioning Excel before moving on to Access.
    My code is for Access. Whilst it will probably work in Excel, I've never tried it,
    In any case, Excel has a built-in zoom capability which makes AFR fairly superfluous I think
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  5. #5
    TonyM is offline Novice
    Windows 10 Office 365
    Join Date
    Jun 2020
    Quote Originally Posted by Missinglinq View Post
    Here's the link @Micron mentioned:

    Linq ;0)>

    Thank you. Will check it out.

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

Similar Threads

  1. Best screen resultion for most common screen sizes
    By sjs94704 in forum Database Design
    Replies: 3
    Last Post: 05-26-2015, 06:12 AM
  2. Lost Help screen for VBA coding
    By dmgg in forum Programming
    Replies: 4
    Last Post: 12-31-2014, 02:50 PM
  3. Login screen coding
    By thinkkwise in forum Access
    Replies: 1
    Last Post: 08-05-2013, 05:08 PM
  4. Find Users screen resolution in twips
    By jsunnb in forum Programming
    Replies: 5
    Last Post: 01-22-2013, 12:09 PM
  5. Different Screen sizes
    By KevinH in forum Access
    Replies: 0
    Last Post: 07-23-2009, 12:07 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 - Senior Forums