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