To put the datasheet below the form in Microsoft Access for Microsoft 365 on Windows, open the form in Design View, press F4 to show the Property Sheet, select the form, and on the Format tab set Split Form Orientation to Datasheet on Bottom. Save the form. The form area will be above the datasheet area when the form opens in Split Form view.
What a split form shows
An Access split form combines two ways to look at the same records: a single-record form and a datasheet resembling a table. The form pane presents the selected record using the controls and layout you designed; the datasheet pane shows multiple records in rows and fields in columns. Putting the datasheet on the bottom is a layout choice, not a separate kind of form or a change to the underlying data.
The two panes are linked. Select a row in the datasheet and the form pane displays that record. Move to another record using the form pane, and the selected row in the datasheet follows. If users edit a field in either pane, the change belongs to the same record and is reflected in the other pane when the record is updated. This makes a split form useful when someone wants to browse a list, then inspect or edit one record in more detail.
The form and datasheet draw from the form’s record source, usually a table or query. The datasheet does not automatically show every field in that source: its columns depend on the fields and datasheet settings available to the form. Likewise, fields on the single-record side can be arranged and labeled for easier entry.
Set the datasheet to the bottom
- In the Navigation Pane, right-click the form and choose Design View. If the form is already open, use the View button on the Home tab or the status bar to switch to Design View.
- Press F4 to open the Property Sheet if it is not visible.
- Click a blank part of the form’s design surface, away from its controls. Check the selection type at the top of the Property Sheet; it should be Form, not Text Box, Detail, or another object.
- Open the Format tab of the Property Sheet and find Split Form Orientation. Choose Datasheet on Bottom from its drop-down list.
- Check the form’s Default View property. Set it to Split Form if you want the form to open with both panes visible.
- Save with Ctrl+S, then switch to Form View to check the result.
Property names can be easier to locate by clicking the Property Sheet’s Format tab and scanning its list, or by using the alphabetical tab if available in your Access build. If the orientation property is missing, confirm that the form itself is selected and that its Default View is set to Split Form. Some form properties are only relevant or available when the form is configured as a split form.
Create a new split form
If you do not yet have a form, select the table or query that should supply its records in the Navigation Pane. On the ribbon, choose Create > More Forms > Split Form. Access creates a form with both panes and opens it for viewing. Switch to Design View and use the orientation steps above to place the datasheet below the form if it is not already there. Review the fields and save the form with a clear name.
Creating the split form from a table or query is a quick starting point, not a requirement that the layout remain unchanged. You can adjust labels, control sizes, tab order, and the fields shown on the form side. Before relying on it for data entry, check that the chosen record source contains the fields users need and that its records can be edited. A query involving joins, totals, or other special operations may not allow updates in the way a simple table-backed form does.
You can also convert or configure an existing form, provided the form supports Split Form view. In Design View, set Default View to Split Form, select the desired orientation, and save. If Split Form is not available for that form, the form’s design or data source may not support the view; creating a new split form from a suitable table or query can be a practical alternative.
Adjust the divider and pane sizes
The horizontal divider between the upper form pane and lower datasheet pane can usually be dragged while the form is open. This lets a user give more vertical room to the record details or to the list, depending on the task and screen size. The divider changes the amount of space each pane occupies; it does not move the datasheet above the form or redesign the form’s controls.
Access also provides split-form properties that affect the divider and how the two views behave. For example, the Split Form Splitter Bar property controls whether the divider is shown, and Save Splitter Bar Position governs whether a changed divider position is retained. Property availability and exact behavior can depend on the Access version and form configuration. If you need a consistent opening layout for users, set and save the relevant form properties, then close and reopen the form to verify the behavior.
Test the layout at the screen size people will actually use. A datasheet with many columns can become difficult to read when the lower pane is short; a detailed form with many controls can feel cramped if the upper pane is too small. Consider hiding unnecessary datasheet columns or simplifying the form rather than expecting users to continually resize the divider.
How the two panes stay in sync
A common misconception is that the bottom datasheet is a second independent copy of the table. It is not. It is another view of the records supplied by the form’s record source, and the form pane and datasheet pane are synchronized around the current record. A user can click a different row to navigate, but the operation does not create a second record or a separate set of values.
Saving a record follows Access’s normal editing behavior. Changes may be committed when the user moves to another record, closes the form, or explicitly saves, depending on the situation. If a user sees a pencil icon or an edited row, the record may still have unsaved changes. Validation rules, required fields, and data-entry restrictions continue to apply. A split form does not bypass them.
Permissions and editability also come from the database and the form’s settings, not from the pane position. If a record source is read-only, or the form’s Allow Edits property prevents changes, showing a datasheet at the bottom will not make those records editable. Conversely, a datasheet view can expose many records at once, so consider whether users should be able to edit them directly before deploying the form.
Common problems and fixes
- The datasheet is still at the top. Return to Design View, select the form rather than a control, and confirm the Format tab’s Split Form Orientation is Datasheet on Bottom. Save and reopen in Form View.
- The Property Sheet does not show the orientation setting. Press F4, click blank form background, and check that the Property Sheet identifies the selected object as Form. Also verify Default View is Split Form.
- The form opens as a regular form with no datasheet. Check Default View. If it is Single Form or another view, set it to Split Form, save, and reopen. Also check the form’s views and data source for compatibility.
- The datasheet has unwanted columns. Review the fields exposed by the record source and the form’s datasheet settings. In Datasheet View, users may be able to hide or reorder columns, but saved design changes should be made deliberately so the opening view is predictable.
- Edits cannot be made. Check whether the record source is updateable, whether the form allows edits and additions, and whether the user has permission to modify the underlying data. The orientation setting does not control edit rights.
- The lower pane is too small. Drag the divider upward to increase the datasheet area, or adjust the saved splitter position if the form’s settings retain it. Also consider reducing the number of columns displayed.
When a split form is a good fit
A split form works well for contact lists, inventory items, service requests, or other records that benefit from both quick browsing and a detailed record view. For example, a staff member could scan a bottom datasheet of service requests, select one row, and read its full description and status in the pane above. It is especially useful when users need to move among records without opening a separate form for each one.
It is less suitable when the datasheet would reveal sensitive fields, when users need a carefully controlled multi-step workflow, or when a complex form cannot be understood alongside a grid. A continuous form can be a better choice when a custom list layout is more important than the datasheet’s rows and columns. A navigation form or separate search form and detail form may suit workflows where users should search first and edit only one record at a time.
Think about the audience as well as the design. Datasheets offer familiar sorting and scanning, but they can make it easy to change a value in the wrong row. If accidental edits are a concern, restrict editing or provide a dedicated review process. The right choice depends on whether fast browsing, controlled entry, or a custom visual layout matters most.
Access version and platform notes
These steps describe the Access desktop application for Microsoft 365 on Windows. Access is a Windows desktop program; there is no equivalent full Access form-design experience in Access for the web, and Access is not available as a Mac desktop application. If you are using a remote Windows computer, the ribbon and Property Sheet steps apply within that Windows copy of Access.
Ribbon wording and the placement of commands can vary slightly among Access releases, but the core approach is to configure the form’s properties in Design View. If an older database opens in a newer version, make a backup before changing its design. When distributing a database, test the form in the same Access environment and with the same permissions that users will have.
Frequently Asked Questions
How do I make the datasheet appear below the form in Access?
Open the form in Design View, select the form itself, and on the Property Sheet’s Format tab set Split Form Orientation to Datasheet on Bottom. Save the form and open it in Split Form view.
Why can’t I see Split Form Orientation?
You may have selected a control or section instead of the form, or the form may not be configured for Split Form view. Press F4, click a blank area of the form, and check that Default View is Split Form.
Can I resize the form and datasheet areas?
Usually, yes. In Form View, drag the divider between the panes. If you want the position retained, review the form’s Save Splitter Bar Position setting and test the form after saving.
Does changing the orientation change the table?
No. It changes where the datasheet appears in the form layout. The form and datasheet still display records from the form’s record source.
Can I put the datasheet on the bottom in Access for Mac or the web?
Access form design is a Windows desktop feature. Access for the web and Mac do not provide the same desktop form-design steps; use a Windows installation of Access to set this property.
Related
- X++ Enum Values in SQL: How Stored Numbers Work in D365
- How to Add Speaker Notes to Your PowerPoint Slides
- What Is Balance in Accounting? Meaning and Examples
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel Clear Print Area: What Dotted Lines MeanTo clear a worksheet’s print area in Excel for Microsoft 365 on Windows, select the sheet and choose…
- Excel Remove Duplicates but Keep One Copy in a ListTo remove duplicates in Excel but leave one copy, select your data and choose Data > Remove Duplicates;…
- Excel Spreadsheet Grouping Rows: How to Create and Use ItTo group rows in Excel for Microsoft 365 on Windows, select the detail rows, then choose Data >…
- Goal Seek in Excel: Step-by-Step InstructionsTo use Goal Seek in Excel for Microsoft 365 on Windows, select Data > What-If Analysis > Goal…
- How to Change Slide Size in PowerPointTo change slide page size in PowerPoint for Microsoft 365 on Windows, open the presentation and select Design…
- Excel Group/Ungroup Shortcut: Keys, Steps, and FixesIn Excel for Microsoft 365 on Windows, select the rows or columns and press Alt+Shift+Right Arrow to group…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.