Report.Resize Event (Access)
The Resize event occurs when a report is opened and whenever the size of a report changes.
Version Information
Version Added: Access 2007
Syntax
expression .Resize
expression A variable that represents a Report object.
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 report in a macro or event procedure—for example, if you use the MoveSize action in a macro to resize the report.
By running a macro or an event procedure when a Resize event occurs, you can move or resize a control when the report 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 report.
When you first open a report, 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 report, and thus cause a cascading event.