Office Settings & Configuration

Reopen a Microsoft Access Split Form at the Same Size and Position

Chanuka GeekiyanageChanuka Geekiyanage Nov 13, 2026 869 views

Question details

The user wants a Microsoft Access split form to reopen with the same dimensions and screen position, while retaining the datasheet layout.

Reopen a Microsoft Access Split Form at the Same Size and Position
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.
Before you start

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.

Solution 1Recommended

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.

1
Open the split form

In the Navigation Pane, right-click the form and select Form View. Confirm that both the form section and the datasheet section are visible.

2
Adjust the window and columns

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.

3
Save and close normally

Press Ctrl+S to save the form, then close it using its Close button. If Access asks whether to save layout changes, choose Yes.

4
Reopen and compare

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.

Save the split form window and datasheet layout
Window size and column width are separate: A consistent outer window size does not guarantee consistent datasheet column widths. If only the columns change, adjust and save the datasheet layout rather than relying on a window-resizing command.
Free Microsoft Office alternative

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.

Review Access data exported to an Excel workbook in WPS Spreadsheet.Supports Microsoft Excel .xlsx, Word .docx, and PowerPoint .pptx formats.Familiar spreadsheet controls make working with exported tables straightforward.Free, lightweight Office tools for documents, spreadsheets, and presentations.
microsoft office alternative - wps office

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.