AutoResize Property

Applies To

Form.

Description

You can use the AutoResize property to specify whether a Form window opens automatically sized to display complete records.

Setting

The AutoResize property uses the following settings.

Setting Description Visual Basic
Yes (Default) The Form window is automatically sized to display a complete record. True (-1)
No When opened, the Form window has the last saved size. To save a form window’s size, open the form, size the window, save the form by clicking Save on the File menu, and close the form. When you next open the form, it will be the saved window size. False (0)


You can set this property in the form’s property sheet, a macro, or Visual Basic.

This property can be set only in Design view.

Remarks

The Form window resizes only if opened in Form view. If you open the form first in Design view or Datasheet view and then change to Form view, the Form window won’t resize.

If a form’s AutoResize property is set to No and its AutoCenter property is set to Yes, and if you make any changes in Design view and don’t switch to Form view before saving the form, Microsoft Access clips the form on the right and bottom edges the next time you open the form.

If the AutoCenter property is set to No, a Form window opens with its upper-left corner in the same location as when it was closed.

See Also

AutoCenter Property, MoveSize Action.