Share via

AutoResize Property [Access 2003 VBA Language Reference]

  • Article

Returns or sets a Boolean indicating whether a Form window or Report window opens automatically sized to display complete records. Read/write.

expression.AutoResize

expression Required. An expression that returns one of the objects in the Applies To list.

Setting

The AutoResize property uses the following settings.

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

You can set this property by using 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 you make any changes in Design view to a form whose AutoResize property is set to No and whose AutoCenter property is set to Yes, switch to Form view before saving the form. If you don't, 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.

Applies to | Form Object | Report Object

See Also | AutoCenter Property