Move a Microsoft Access Form to the Upper-Left Corner
Question details
The user wants an Access form to open in the upper-left corner.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Positioning a form when it loads using a VBA event procedure.
- Observed behavior
- The form does not consistently move to the upper-left when Form.Move Left:=0, Top:=0 is used in the On Load event.
Open the database in Microsoft Access and identify the form you want to position. Make sure the database content is enabled so its VBA event procedures can run.
Set the Form Position in Its Load Event
Use the form's Move method and disable Auto Center to position the form when it opens.
In the Navigation Pane, right-click the form and select Design View. Open the Property Sheet and select Form.
On the Property Sheet's All tab, set Auto Center to No.
On the Event tab, set On Load to [Event Procedure], then select the ellipsis button to open the VBA editor.
In the Form_Load procedure, enter: Me.Move 0, 0, 5000, 5000. The first two values set the position; the last two set the width and height.
Save the form, close it, and reopen it from the Navigation Pane to check its position.

Use DoCmd.MoveSize to Position the Form
Use this alternative VBA command in the form's Load event to set its position and size.
Work With Exported Access Data in WPS Spreadsheets
WPS Office is a free, lightweight alternative for everyday documents and spreadsheets, with a familiar interface that makes it easy to move compatible Office files. Use WPS Spreadsheets to review data exported from Access; WPS does not run or reposition Access forms.

Frequently Asked Questions
Why does my Access form keep opening in the center?
Open the form in Design View, select Form in the Property Sheet, and set Auto Center to No. Then save and reopen the form.
Does 0, 0 put the form at the corner of my monitor?
Not necessarily. The Move coordinates are relative to the containing window, so the form may appear at the upper-left of the Access workspace rather than the physical screen.
What do the numbers in Me.Move mean?
In Me.Move 0, 0, 5000, 5000, the values specify left, top, width, and height in twips. Approximately 1,440 twips equal one inch.
Why doesn't the form move when it opens as a tab?
Tabbed forms are not displayed as independent overlapping windows. Check File > Options > Current Database > Document Window Options, select Overlapping Windows if appropriate, and reopen the database.
Can WPS Office run my Access form?
No. WPS Office does not run Access forms or fix their positioning. You can export Access data to an Excel file and open it in WPS Spreadsheets.




