Denver Area Access Users Group

General Meeting Presentation

Thursday, February 17, 2022

Colin Riddington, Mendip Data Systems

Automatic Form Resizing in Access

Colin Riddington, Mendip Data Systems

IMPORTANT: This presentation is at 10:30 AM Mountain Time

All developers will be aware that forms designed for a specific screen size or resolution may look dreadful on a different monitor with a different resolution or screen size or shape. Automatic form resizing (AFR) code is designed to fix all such issues. Using AFR, forms and their controls can be automatically resized and repositioned for any screen size & resolution whilst allowing developers full control over the form layout and appearance. AFR code works with all types of form (including split forms, navigation forms and datasheets) and with both overlapping windows and tabbed documents display modes. This session will explain how the code works and provide tips for using the code most effectively in your own applications.

Colin has been an Access developer for over 20 years starting with Access 97, with many years teaching in secondary schools including responsibility for data analysis. He initially created Access apps for his own use and later for all staff in a number of UK schools. His websites include many Access articles, example apps, sample code and security challenges, together with commercial applications for businesses, schools and developers. His focus is on stretching the boundaries of what can be achieved using Access.

Download the presentation materials

Watch the recorded video of Automatic Form Resizing in Access on our YouTube channel