Automatically Expand or Contract an Access form to Show More or Less Controls ~ DataPig
Clever technique to expand or contract a form’s size by showing or hiding a section depending on which controls are being displayed. In the sample, a Login form is displayed and the form is sized to show relevant information. There is an optional set of controls in the form footer section which is initially not visible. The form can be automatically expanded to show all information. This is accomplished by use of the FormFooter to house the second set of controls. The password controls are displayed/hidden by making the form footer visible or not visible and then acCmdSizeToFitForm is run - simple and effective.
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.