Creating forms that support each user's screen is challenging in Microsoft Access. Developers commonly create forms for the smallest resolution and size, which makes it inefficient for users with larger screens and higher resolutions. Users want to maximize their forms or manually resize them and see more data. MS Access forms have a Resize event, but it's difficult to write the VBA code to resize each control and update the code when controls are added or deleted.
The Resize control in Total Access Components eliminates this complexity and offers features beyond simple resizing. It automatically knows all the controls on your form when it's initialized and adjusts them accordingly.
You can even adjust font size. This is particularly valuable if the form shrinks and you still want to show the same text in the smaller box.
After placing the Resize control on your form, enabling form resizing only requires two lines of VBA code:
You can optionally set the maximum and minimum height and width to constrain the limits of the resizing.
Supports Microsoft Access 2016, 2013, 2010, 2007, 2003, 2002, and 2000