Resize Event [Access 2003 VBA Language Reference]
The Resize event occurs when a form is opened and whenever the size of a form changes.
Private Sub Form_Resize()
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
Note 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 clicks 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
Applies to | Form Object