Set the size and position of a form or report

Microsoft Office Access 2003

  1. Open a form in Form view or a report in Print Preview.
  2. Size the form or report by dragging the borders of the window.
  3. Click Save Button image on the toolbar.

Note  If the AutoResize property is set to Yes, Microsoft Access automatically sizes the form or report to display complete records. To set the form or report window to the size you want, make sure the AutoResize property is set to No. The AutoResize property for a report is not available in Microsoft Access 2000 or earlier.

ShowCenter a form or a report in the application window when it's first opened

  1. Open a form or report in Design view.
  2. Double-click the form selector or report selector to open the property sheet.
  3. Set the AutoCenter property to Yes.

    The next time you open the form or report, it will be centered in the application window.

Note The AutoCenter property for a report is not available in Microsoft Access 2000 or earlier.

ShowSize a form to fit its contents

  1. Open a form in Form view.
  2. On the Window menu, click Size To Fit Form. If the Form window is maximized, the command is not available.
  3. Click Save Button image on the toolbar to save the size of the form.

Note  If the form's DefaultView property is set to Single Form, and the displayed record is smaller than the Form window, Size To Fit Form crops the window to the size of the record. If the record is larger than the Form window, Size To Fit Form expands the Form window to show as much of the record as possible. If the property is set to Continuous Forms, and only part of the bottom record is displayed, Size To Fit Form crops that record. If only one record is partially displayed, Size To Fit Form enlarges the window to show as much of the record as possible.