Resize Form with vba ACCESS 2003

Posted on 2012-09-18
Last Modified: 2012-09-18
I have a form that if the user selects a certain definer code, I need the form to expand to reflect a sub-form.  The sub-form only is relative to one particular definer code condition.  I can find the width property of the form, but how do I dynamically resize a form with vba?

Question by:ssmith94015
    LVL 56

    Accepted Solution


     With the Move/Size command, but it's not simple; every control needs to be re-sized as well.

     In fact it's a down right tricky process at times.  You need to be carefull with the elements and fonts that you use as well (not everything resizes well).

     My suggestion would be to pickup a copy of the Access Developers Handbook published by Sybex which has that code already, or buy Shrink Stretcher (a commerical product).

     You'll be way ahead time wise rather then trying to figure it all out and re-inventing the wheel.

    LVL 56

    Expert Comment

    by:Jim Dettman (Microsoft MVP/ EE MVE)
    BTW, here's a link for Shrink Stretcher:


    Author Closing Comment

    Thanks Jim.  The references were excellent.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
    This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA.…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    22 Experts available now in Live!

    Get 1:1 Help Now