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()
End Sub

Private Sub Form_Resize()
End Sub

Applies to | Form Object

See Also | Current Event | Repaint Method | SetFocus Method