Results 1 to 8 of 8
  1. #1
    cheloto is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    7

    How to Automatically Resize All the Controls of Your Form

    I am tying to make the Visual Basic code, but can't find the working solution.
    Can anyone give me the script - It would be grate

  2. #2
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    nowhere near enough information to clarify exactly what you mean, but if you google your question you will find many links like the one below - one of them will probably meet your requirements

    https://codereview.stackexchange.com...rm-dynamically

    If not, explain exactly what you mean

  3. #3
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    See my tutorial on automatic form resizing http://www.mendipdatasystems.co.uk/a...g-1/4594554784
    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

  4. #4
    cheloto is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    7
    I have created a program in Access where the main menu consists of many boxes of text. This is customized to a screen resolution, but I want the image to zoom and adapt to all different screen sizes. Thought this was a simple command at opening form_load, but I'm not good enough to see the solution. Believe someone had the same desire and found the solution. Was this understandable?

  5. #5
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    Have you looked at Colin's link?

  6. #6
    cheloto is offline Novice
    Windows 10 Access 2016
    Join Date
    Jul 2019
    Posts
    7
    Yes, but I can't find something like Resize

  7. #7
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    there are 2 factors in resizing, resolution and form size. Colin's link covers both.

    You won't find a simple 'resize' command. there is the form resize event where you can put code to adjust control sizes referencing the form insidewidth and insideheight properties, or you can automate using the anchoring properties of a control. I use the former as it gives you more control

  8. #8
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,954
    Suggest you try the supplied example app from my link and see how it works in practice
    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. Resize controls based upon List Box selection
    By Bcanfield83 in forum Forms
    Replies: 2
    Last Post: 01-04-2019, 10:55 AM
  2. Subreport Won't Resize Controls in VBA
    By evenlater in forum Reports
    Replies: 14
    Last Post: 07-08-2018, 06:40 PM
  3. Move form controls according to subform resize
    By Lukael in forum Programming
    Replies: 8
    Last Post: 12-06-2015, 01:36 PM
  4. Replies: 1
    Last Post: 03-27-2012, 12:23 AM
  5. Resize form automatically
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 08-30-2010, 10:24 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