Reopen a Microsoft Access Split Form at the Same Size and Position
Question details
The user wants a Microsoft Access split form to reopen with the same dimensions and screen position, while retaining the datasheet layout.

- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Resize a split form and its datasheet columns, save the changes, and reopen the form with a consistent layout.
- Observed behavior
- The split form may reopen with different dimensions or datasheet column widths even after its resize was saved.
Check whether the form opens in Form view or Datasheet view, and whether the database uses tabbed documents or overlapping windows. Window position and size controls apply to movable form windows, not ordinary document tabs.
Save the split form window and datasheet layout
Use this first to check whether saving the form preserves its window dimensions and datasheet column widths.
In the Navigation Pane, right-click the form and select Form View. Confirm that both the form section and the datasheet section are visible.
If the form is displayed in a movable window, drag its borders to the desired size and move it to the desired position. In the datasheet section, drag column-header boundaries to set the required column widths.
Press Ctrl+S to save the form, then close it using its Close button. If Access asks whether to save layout changes, choose Yes.
Open the form again from the Navigation Pane. Check the outer window dimensions separately from the datasheet column widths to identify which part is resetting.

Apply a fixed window size and position in the form's Open event
Use this when saving the layout does not preserve the dimensions of a movable form window.
Use WPS Office to Work with Data Exported from Access
WPS Office does not fix Access form sizing or run Access databases. It offers free, lightweight tools with a familiar interface for reviewing data exported to Excel, alongside Microsoft Office format compatibility for an easy transition in everyday document work.

Frequently Asked Questions
Why does my split form change size even after I save it?
The outer window and datasheet layout are separate, and automatic form settings can also affect the result. Save with Ctrl+S, close normally, and reopen in the same view. If the outer window still resets, check Auto Resize and Auto Center in Design View > Property Sheet > Format, then consider an Open event procedure.
Can DoCmd.MoveSize preserve the datasheet column widths?
No. DoCmd.MoveSize changes the active window's position and outer dimensions. Set column widths by dragging the datasheet column-header boundaries, then save the form and accept any prompt to save layout changes.
Why can't I move my Access form to a specific position?
An ordinary tabbed document does not have an independent window position. Check File > Options > Current Database > Document Window Options. Overlapping Windows allows movable document windows; reopen the database after changing the setting if prompted.
What units should I use in DoCmd.MoveSize?
Use twips, with 1,440 twips per inch. The arguments are Right, Down, Width, and Height. For example, DoCmd.MoveSize 1440, 1440, 10080, 7200 requests one-inch offsets and a seven-by-five-inch window.
Can WPS Office open and resize an Access form?
No. WPS Office does not run Access forms or edit .accdb database applications. Make the form changes in Microsoft Access. To review the underlying data in WPS Spreadsheet, export it from Access through External Data > Export > Excel, then open the exported workbook in WPS.




