AL: Automatic Form Resizing in Access, by Colin Riddington (isladogs)

Automatic Form Resizing, AFR, is a free tool with source code that you can download and use to resize and reposition Microsoft Access forms on the fly for users with different screen resolutions. You can also zoom forms. Automatic Form Resizing by Colin Riddington (isladogs -- https://www.isladogs.co.uk ) 28 Sept 2021 download latest version, as of 9 Dec 2021 (includes resizing datasheets and navigation forms) https://isladogs.co.uk/dl/afr/afr.zip download presentation: https://isladogs.co.uk/dl/afr/afr_ppt... 3 articles to explain how it works: 1 https://isladogs.co.uk/automatic-form... 2. https://isladogs.co.uk/automatic-form... 3. https://isladogs.co.uk/automatic-form... 00:00 Access Lunchtime, hosted by Maria Barnes last Tuesday of each month, 12 noon Central Time 00:31 welcome Colin 00:47 Automatic Form Resizing in Access (AFR) -- why use it? 00:59 Colin's was a secondary school teacher when be began building Access databases 03:18 Why use automatic form resizing (AFR)? 03:45 long-time developers will have seen issues with different screen sizes 03:45 old applications may have text too small to read on high resolutions (big monitors) 04:01 or maybe users are on tablets 04:23 One alternative is form layouts with grouping and anchoring. Monitors variety of screen sizes, maybe 10" to 24", different form factors or shapes 05:10 Accessibility -- make sure forms remain useable 06:30 Grouping and Anchoring looks a mess when maximized 06:20 what happens when its resized with AFR? 07:47 list of what happened 09:32 one line of code in Form Load event: ResizeForm Me 09:58 example with pictures -- find out GPS location, and also which direction you were facing 10:45 example with currency exchange rate tracker 10:58 example with a variety of different controls - labels, buittons, comboboxes, listboxes, toggle buttons, rectangles, option groups, tab controls, images, hyperlinks, lines, and charts 11:32 using Zoom 12:10 Split Forms - difficult to work with -- remove Splitter Bar 13:02 example with application interface hidden 13:14 typical form resizing VBA code 14:50 form with grouping and anchoring 15:18 messes up badly when maximized 15:34 Anchoring possibilities 15:54 open same form with automatic form resizing code instead of grouping 16:22 form with lots of control types 16:45 Tag, Locked, Enabled 16:52 Using Tags A,B,C,D to alter the state of several controls at once 17:47 Disable C, Hide A, Lock B 18:05 default screen resolution is 1680 x 1050, ratio of horizontal to vertical is 1.6 18:21 in design view, form is smaller 20:14 change screen resolution 23:03 tab controls and option groups can cause problems 23:17 what about continuous forms? 25:05 popup form with zoom 26:34 split form - remove Splitter Bar 27:19 hidden dotted line as marker 29:24 Form Un-Resizer 32:12 VBA originally written by Jamie Czernik 33:30 constants - horizontal resolution most important 35:51 vertical resolution constant no longer used 37:43 never changed dots per inch 38:11 APIs defined for 64 and 32 38:17 screen shape is form factor 38:30 multiplying factor 39:03 main resize code 39:36 tabbed documents 40:09 resize form sections and controls by multiplying factor 40:40 Height, Left, Top, Width 40:54 contents of controls - FontSize, ColumnWidths, ListWidth, TabFixedWidth, TabFixedHeight 42:13 ZoomForm 42:52 avoid having anything with a frame in bottom right 45:14 ResizeForm on Form_Load 45:52 UpdateFormZoom 47:04 How to get the best results from AFR 49:28 maximum form width 22.75 inches (57.79 cm) – even with AFR 50:05 TWIPs 50:47 if Long used instead of Integer, forms could be much bigger 51:16 use with ACCDE, MDE? Yes! and Runtime too. 51:47 Automatic Form Resizing articles -- first of 3 https://www.isladogs.co.uk/automatic-... 52:29 questions 53:30 forms not being saved, just being adapted to circumstances 53:56 what about user being prompted to save, and what about subforms? 56:46 does it work with navigation controls? ... do you mean navigation forms? UPDATE: Yes - WITH CARE. Remove layout guides before using with AFR 1:01:38 join us 30 November 2021 for presentation by Peter Cole on 32 to 64-bit AccessUserGroups.org Lunchtime chapter lead by Maria Barnes Last Tuesday @ noon Central time CT -- join us! https://accessusergroups.org/lunch/ SUBSCRIBE for MORE videos! ► https://bit.ly/AUGYoutube ✓ Join our online Access User Groups free https://accessusergroups.org/ ► Facebook ◄   / accessusergroups