Others

How to Center a Microsoft Access Dialog Form on the Screen

Olivia MillerOlivia Miller Nov 13, 2026 868 views

Question details

The user needs to center a Microsoft Access dialog form automatically or adjust its position with VBA because it currently touches the top of the screen while side and bottom spacing are correct.

Product
Microsoft Access
Device & OS
not provided
Scenario
The user has an Access dialog form that is positioned correctly on the sides and bottom but touches the top of the screen, and wants it centered automatically or adjusted via VBA.
Observed behavior
The dialog form touches the top of the screen while the side and bottom spacing are correct.
Before you start

Open the form in Design View and make sure the Property Sheet is available before changing layout properties. Decide whether you want automatic centering or exact manual positioning with VBA.

Solution 1Recommended

Set AutoResize to No and AutoCenter to Yes for Automatic Centering

Use this solution when you want Microsoft Access to center the dialog form automatically every time it opens, without writing VBA code.

AutoCenter centers a form in the Access window on startup, while AutoResize controls whether Access adjusts the form size. Saving the form from Form view ensures the property change is retained.

1
Open the form in Design View

In Microsoft Access, open the database, select the form in the Navigation Pane, then right-click it and choose Design View.

2
Open the Property Sheet

Press F4 or click the Property Sheet button on the Design tab to display the form properties.

3
Set AutoResize and AutoCenter

On the Format or All tab, set AutoResize to No and AutoCenter to Yes.

4
Save from Form View

Switch to Form View, then press Ctrl+S or right-click the form tab and save the form so the centering behavior is retained.

Set AutoResize to No and AutoCenter to Yes for Automatic Centering
Automatic centering enabled: The form will now center automatically when opened.
Free Microsoft Office alternative

Use WPS Office as a Free, Lightweight Alternative to Microsoft Access Form Projects

Because Microsoft Access form centering and VBA positioning are specific to Microsoft Office, WPS Office does not change those settings. For users who want a free, lightweight Office suite, WPS Office provides familiar Writer, Spreadsheet, and Presentation tools with strong Microsoft Word, Excel, and PowerPoint format compatibility and an easy migration path.

  1. 1. Download WPS Office: Go to the official WPS Office download page, click Download WPS Office Free, and run the installer to set up the suite.
  2. 2. Open your existing Office files: Launch WPS Office, click the Open button or Menu, and choose an existing Word, Excel, or PowerPoint file to open it directly.
  3. 3. Use the familiar ribbon tools: Select the Writer, Spreadsheet, or Presentation tab from the WPS Office home screen to start editing with a familiar Microsoft Office-style interface.
Avoid Access-only form-positioning issues by working in a simpler Office workflowFree, lightweight office suite without subscription feesCompatible with Microsoft Word, Excel, and PowerPoint file formatsFamiliar ribbon interface for quick migration from Microsoft OfficeOpens and saves .docx, .xlsx, and .pptx files seamlessly
microsoft office alternative - wps office

Frequently Asked Questions

Why does AutoCenter still leave my Access form touching the top of the screen?

Set AutoResize to No and AutoCenter to Yes in the Property Sheet, then switch to Form View and save the form. Reopen it so Access applies the centered position.

What units should I use with DoCmd.MoveSize in Access?

DoCmd.MoveSize uses twips. One inch equals 1,440 twips, so the command DoCmd.MoveSize 1440, 1440, 5760, 5760 places the form 1 inch from the top and left and makes it 4 inches wide and high.

Can I use the form's On Open event to move an Access dialog form instead of AutoCenter?

Yes. Open the form in Design View, select the On Open event in the Property Sheet, click the build button, choose Code Builder, and enter DoCmd.MoveSize or Me.Move with your desired values.

Does WPS Office have an Access database or dialog form designer?

No. WPS Office includes Writer, Spreadsheet, Presentation, and PDF tools rather than an Access-style database form designer, but it opens and edits Word, Excel, and PowerPoint files.

Where do I find AutoCenter and AutoResize in Access?

Open the form in Design View, press F4 to open the Property Sheet, and look on the Format or All tab. Set AutoResize to No and AutoCenter to Yes.