Making Automatic Form Resizing Work for You

This is a modified version of a presentation I gave to the online Access DevCon conference on 28 April 2023. For more information and all files referenced in this video, see https://isladogs.co.uk/using-afr/

A detailed 4-part series of tutorials is also available starting with https://isladogs.co.uk/automatic-form...

TIMES:
0:00 Intro
0:36 Why use Automatic Form Resizing? (AFR)
2:38 Example form using AFR
2:50 What happens using AFR?
4:35 Seven more examples of forms using AFR
7:58 CODE - Module modResizeForm declarations and scaling factor
9:58 CODE - Typical AFR code in forms and subforms
11:15 DEMO - Example AFR app showing resizing on all standard Access controls
12:37 Controls that cannot be resized: checkboxes/option buttons/images on command buttons...together with workarounds
14:15 DEMO - change monitor / resolution & scaling factor - resizing handles all of these perfectly
16:26 DEMO - form zoom to suit individual user preferences
17:23 DEMO - Stretch / shrink forms 'on the fly' as they are resized manually
19:15 DEMO - Resize datasheet subform / form
20:07 DEMO - Split forms & navigation forms
20:59 DEMO - Report as subform
21:25 How to get the best results from AFR
23:52 Using AFR to resize existing apps
24:18 DEMO - Reduce size of 'over-large' form
26:24 DEMO - Resize better date picker form with multiple re-draws
30:15 DEMO - Resize Northwind 2000 database - complex old database with many/varied forms of different types
37:05 CODE - ResizeForm & Resize procedures
39:37 CODE - Zoom form procedures
40:39 CODE - Stretch/shrink procedures
41:39 CODE - Datasheet form/subform procedures
42:40 Links to web article
43:10 Links to tutorial articles
43:24 Thanks for watching