How to Center a Microsoft Access Dialog Form on the Screen
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.
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.
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.
In Microsoft Access, open the database, select the form in the Navigation Pane, then right-click it and choose Design View.
Press F4 or click the Property Sheet button on the Design tab to display the form properties.
On the Format or All tab, set AutoResize to No and AutoCenter to Yes.
Switch to Form View, then press Ctrl+S or right-click the form tab and save the form so the centering behavior is retained.

Position the Form Manually with DoCmd.MoveSize in the On Open Event
Use this solution if you need a specific top, left, width, or height in twips, or if automatic centering is not suitable for your layout.
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. 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. 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. 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.

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.




