Form.Resize event (Access)
The Resize event occurs when a form is opened and whenever the size of a form changes.
expression A variable that represents a Form object.
To run a macro or event procedure when this event occurs, set the OnResize property to the name of the macro or to [Event Procedure].
This event occurs if you change the size of the form in a macro or event procedure—for example, if you use the MoveSize action in a macro to resize the form.
By running a macro or an event procedure when a Resize event occurs, you can move or resize a control when the form it's on is resized. You can also use a Resize event to recalculate variables or reset properties that may depend on the size of the form.
When you first open a form, the following events occur in this order:
Open → Load → Resize → Activate → Current
You need to be careful if you use a MoveSize, Maximize, Minimize, or Restore action (or the corresponding methods of the DoCmd object) in a Resize macro or event procedure. These actions can trigger a Resize event for the form, and thus cause a cascading event.
The following example shows how a Resize event procedure can be used to repaint a form when it is maximized. When the user chooses a command button labeled Maximize, the form is maximized and the Resize event is triggered.
To try the example, add the following event procedures to a form named Contacts that contains a command button named Maximize.
Private Sub Maximize_Click() DoCmd.Maximize End Sub Private Sub Form_Resize() Forms!Contacts.Repaint End Sub
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.