Private Sub Form_Resize()
Remarks
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
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.
Example
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