MS Access Split Form: Put the Datasheet on the Bottom

How-to basics · Updated November 22, 2026

Yes. In Microsoft Access, set the form’s Split Form Orientation property to Datasheet on Bottom. Open the form in Design View, press F4 to show the Property Sheet, and choose that setting on the Format tab; save the form to retain the layout.

What a split form does

An Access split form displays the same records in two linked views: a single-record form pane and a datasheet pane. The form pane presents one record in a layout you can design with labels, text boxes, and other controls. The datasheet presents multiple records in rows and columns, similar to a table or query. With the datasheet on the bottom, the form pane is above it.

The panes are synchronized. Selecting a row in the datasheet displays that record in the form pane, and moving to another record in the form pane changes the current row in the datasheet. This makes the arrangement useful when you want to scan a list and inspect or edit one selected record without opening a separate form.

A split form is not simply a datasheet placed inside an ordinary form. Access provides a special form view that manages the two views together. The orientation setting controls which side or end contains the datasheet; it does not change the order of fields in the underlying table or query.

Put the datasheet below an existing form

  1. In the Navigation Pane, right-click the form and choose Design View.
  2. Press F4 to open the Property Sheet if it is not already visible.
  3. Click the small form selector at the upper-left corner of the form design surface, where the rulers meet. This selects the form itself rather than an individual control.
  4. On the Property Sheet’s Format tab, find Default View. Set it to Split Form if the form is not already a split form.
  5. Find Split Form Orientation and select Datasheet on Bottom.
  6. Save the form, then open it in Form View to check the result.

The exact visible arrangement depends on the form’s size and the position of its divider. If you do not see the orientation property, check that you selected the form rather than a text box, and that Default View is set to Split Form. The property is relevant to a split form, not to a regular single-form or continuous-form layout.

Create a new split form with this layout

For a new form, select the table or query in the Navigation Pane, then use Create > More Forms > Split Form. Access creates a form based on that record source and opens it for editing. Save it with an identifiable name, then use Design View and the Property Sheet to confirm or change Split Form Orientation to Datasheet on Bottom.

Creating a split form this way is a quick starting point, not a guarantee that the generated design is ready for users. Check that the form is based on the intended table or query, that the fields shown in the form pane are useful, and that the datasheet includes the columns people need. You can adjust the form’s controls in Design View while retaining its split-form behavior.

Adjust the divider and the amount of space

The orientation chooses the datasheet’s location; the divider determines how much room each pane receives. In Form View, move the pointer over the horizontal bar between the upper form and lower datasheet. When the pointer indicates that the divider can be moved, drag it up or down. Give the upper pane enough height to display its controls and the lower pane enough height to show the number of rows users need to compare.

If the divider is difficult to find, maximize the Access window and inspect the boundary between the panes. A short window, large ribbon, or crowded form can make the datasheet appear to be missing when it is actually compressed. You can also review the split-form properties on the form’s Format tab, including the options governing the splitter bar and split-form size. Property availability and wording can vary by Access version, so use the Property Sheet’s descriptions rather than changing unrelated form settings.

Save the form after setting its orientation and arranging the panes. If users open the form at different window sizes, check it at a typical working size as well as maximized. A layout that looks fine on a large monitor may leave too little room for the datasheet on a smaller display.

How records and edits behave

Both panes show records from the form’s record source. In a straightforward, editable form, a user can select a datasheet row and edit that record in the upper form, or edit an editable cell directly in the datasheet. Access normally saves a record when the user moves to another record or otherwise commits the edit. The split layout itself does not make a read-only record source editable.

Whether records can be changed depends on the form’s data source and settings. A query involving certain joins, calculated fields, or grouped totals may not be updateable. Form properties such as Allow Edits, Allow Additions, and Allow Deletions also affect what users can do. If users can browse but cannot change data, check those conditions rather than assuming the orientation setting is responsible.

The datasheet is especially helpful for choosing a record, sorting, or scanning several rows. The form pane is better for entering or reviewing fields that need labels, larger text boxes, or a carefully arranged layout. However, split forms are not a substitute for a purpose-built workflow: a form may need validation, clear instructions, or restricted editing to suit its audience.

Arrange datasheet columns and form controls

The two panes can be configured separately. In the upper form pane, use Design View to move, resize, or remove controls and to add labels or other appropriate controls. Be careful not to remove a field users need in the datasheet just because it is not needed in the upper pane; the form layout and datasheet columns are not identical design surfaces.

To adjust the datasheet, switch to Form View and work with its columns. You can change column widths and order, and hide columns that are not useful to the audience. For example, a customer form might show name, city, and status in the datasheet while the upper pane displays the selected customer’s address and contact details. Avoid hiding a field users rely on to distinguish similar records.

Datasheet appearance and saved column arrangements can depend on the form and how users open it. Test the saved form after closing and reopening it, especially if column order or visibility matters to a shared workflow. If you need a highly customized grid with different behavior from the form pane, a separate datasheet form or a dedicated continuous form may be easier to maintain.

Common problems and practical checks

  • The datasheet is on top: Open the form in Design View, select the form, and set Split Form Orientation to Datasheet on Bottom.
  • The orientation option is missing: Confirm that the form itself is selected and Default View is Split Form. A normal form cannot use the split-form orientation property in the same way.
  • The datasheet seems gone: Look for the divider and drag it to give the lower pane more height. Also check whether the form window is too small.
  • Changes do not remain: Save the form after changing its properties or layout, close it, and reopen it to verify the saved design.
  • A field or record cannot be edited: Check the record source’s updateability and the form’s edit permissions. Changing the pane position will not resolve a read-only source.
  • Columns are cramped or missing: Adjust widths and column visibility in the datasheet, then verify the layout after reopening the form.

One common misconception is that moving the datasheet to the bottom changes the underlying data or table structure. It does not. Orientation affects how the form is presented; the record source and field definitions determine what data the form displays.

When to use a split form instead of another view

Choose a split form when people need both a browsable list and a detailed view of one selected record on the same screen. It can reduce the need to switch between a separate datasheet and a separate form. The bottom-datasheet arrangement is often comfortable when the detailed form needs the upper area and users want to scan rows below it.

A single form is a better fit when the task is focused on one record and a list would distract or take up needed space. A continuous form displays multiple records in a form-based layout, which can be useful when each row needs a more visual arrangement than a datasheet allows. A standalone datasheet is suitable for tabular work but provides less control over the presentation of an individual record. Pick the view based on the task and the users’ screen size, not merely on which layout takes the fewest clicks to create.

Frequently Asked Questions

Can I put the datasheet at the bottom of an Access form?
Yes. Set the form’s Split Form Orientation property to Datasheet on Bottom. The form pane will be above the datasheet pane.

Where is Split Form Orientation in Access?
Open the form in Design View, select the form itself, and press F4 to show the Property Sheet. Look on the Format tab. Set Default View to Split Form if needed, then choose the desired orientation.

Why can’t I see the Split Form Orientation property?
You may have selected a control instead of the form, or the form may not be set to Split Form. Click the form selector at the upper-left of the design surface and check Default View on the Format tab.

Can I move the divider between the form and datasheet?
Yes. In Form View, drag the horizontal divider to change how much space each pane receives. The divider changes pane size, while Split Form Orientation determines which pane is above or below.

Does a split form automatically allow editing?
No. Editing depends on the record source being updateable and on the form’s data permissions. A split form can display records even when its source or settings prevent changes.

Will the layout change my table or query?
No. The orientation changes the form’s display, not the table structure or query logic. The form continues to show records from its configured record source.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.