A split form in Microsoft Access shows the same records in two panes: a single-record form and a datasheet grid. Selecting a row in the grid displays that record in the form pane, so you can scan many records and inspect or edit one in detail without opening a separate form. It is a built-in Access form layout, not a special kind of database table or a separate product.
What a split form means in Access
In Access, a split form combines Form view and Datasheet view in one window. The form pane presents one record at a time using controls such as text boxes, labels, and combo boxes. The datasheet pane presents records as rows and fields as columns, much like a table or query opened in Datasheet view. Both panes are tied to the form’s record source and stay synchronized as the current record changes.
For example, a customer form might show a list of customer names and cities in the datasheet pane. Clicking one customer’s row brings that customer’s address, phone number, and account details into the form pane. If the form is configured to allow edits and the underlying record source supports them, changes made in either pane apply to the same record.
This arrangement is useful when a plain datasheet is too cramped for detailed entry, but a conventional form makes it difficult to browse quickly through a long list. It does not create a second copy of the data: both views are two ways of displaying records from the same source.
Background and where the term comes from
Split form is Microsoft Access’s name for this combined layout. Microsoft introduced the split-form feature in Access 2007. The name describes the visible division between a form-style pane and a datasheet-style pane; it is not a general database term with a separate technical meaning across all database programs. Other applications may offer similar two-pane interfaces but use different names or behave differently.
In ordinary Access use, people may say things such as, “I made a split form for the contacts table,” or, “The split form lets staff browse orders and edit the selected one.” These are standard descriptions of an Access feature, not slang or nonstandard wording. Strictly speaking, the form is usually bound to a table or query rather than to a table alone, so the more precise description is that it displays records from its record source.
How to create a split form
In desktop Microsoft Access for Windows, a quick way to create one is to select a table or query in the Navigation Pane and use the Create tab. The command is in the Forms group under More Forms > Split Form. Access creates a form based on the selected object and opens it in a view where you can inspect and adjust the layout.
- In the Navigation Pane, select the table or query that should supply the records. Selecting it does not open it; it identifies the source for the new form.
- Choose Create > More Forms > Split Form on the ribbon.
- Check that the displayed records and fields are the ones you expect. Save the form with a useful name using Ctrl+S on Windows.
- Switch to Layout view or Design view if you need to change controls, labels, column widths, or the pane arrangement.
The command creates a starting point, not a guarantee that the form will suit every task. Review its record source, displayed fields, and edit behavior before putting it into regular use. Access menus and available features can differ by edition and update; the instructions above refer to the desktop Access ribbon, not Access in a browser.
How the two panes work together
The datasheet is a compact way to navigate and compare records. A user can select a row, and the form pane then shows the selected record. Moving to another record through the form’s navigation controls also changes the selected record in the datasheet. The panes are not independent lists, and selecting a row does not open a separate record or create a new copy.
Edits depend on the form’s settings and the capabilities of its record source. Access forms have properties such as Allow Edits, Allow Additions, and Allow Deletions that affect what users can do. A query may also be read-only or otherwise non-updatable, depending on how it is constructed. A split form cannot make a read-only source editable; if updates fail, check both the form’s permissions and whether the source query supports updates.
Sorting or filtering the datasheet can help locate records, but users should understand whether a filter is active before assuming records are missing. A filtered view shows only matching rows; it does not necessarily delete or hide those records from the database. The form pane continues to represent the current record in the form’s recordset.
Choosing the layout and adjusting the form
A split form can place the datasheet above or below the form pane, or to its left or right. Choose an arrangement that suits the screen and the information: a vertical stack often gives the datasheet more horizontal room, while a side-by-side layout can work well on a wide display. The ideal choice depends on field lengths and how much detail the form pane needs to show.
To change the arrangement, open the form in Layout view or Design view, open the Property Sheet (F4 on Windows), select the form itself, and look for the Split Form Orientation property on the Format tab. The available choices specify whether the datasheet is on top, bottom, left, or right. If the property sheet is showing a text box or another control, select the form rather than the control before changing a form-level setting.
Other practical adjustments include resizing the panes with the divider, changing datasheet column widths, and arranging or resizing controls in the form pane. Save the form after making changes, then reopen it in its normal view to check how it looks with realistic records. A layout that works with short sample names may become hard to use when actual data contains long addresses or descriptions.
When a split form is a good choice
A split form is especially useful when a person needs both a record list and a clear detail view. It can suit contact directories, product lists, staff records, or simple order headers where a user often moves between records and needs to inspect several fields. It may also be a convenient internal data-entry screen when users need to locate an existing row before correcting or completing it.
Consider it when these conditions apply:
- Users need to browse or compare multiple records, then focus on one record at a time.
- The form pane can show important details more clearly than a wide datasheet alone.
- The record source is suitable for the required viewing or editing tasks.
- The available screen space is sufficient for both panes to remain legible.
It is less suitable when a user must enter a carefully ordered sequence of fields, when the record contains many related child records, or when the datasheet becomes too wide to navigate. A split form is also not automatically a good public-facing interface: a polished application may need a custom navigation form, role-specific screens, or controls that guide users through a particular workflow.
Common problems and misconceptions
A frequent misunderstanding is that the two panes show different records. They do not: the form pane is the detailed view of the current record in the datasheet. Another misconception is that creating a split form changes the original table. It creates a form object; the table’s structure and data are not transformed merely because the form uses a split layout.
If a field appears in one pane but not where expected in the other, check the form’s record source, the available fields, and the form’s layout. The datasheet and form panes have different presentation rules, so changing a control’s position in the form pane does not necessarily arrange datasheet columns the same way. Adjust the relevant pane and save the form.
If the form will not accept edits, check whether the form is read-only, whether Allow Edits or Allow Additions is disabled, and whether the underlying query is updatable. If the pane divider is difficult to use or the layout looks cramped, inspect the split-form settings and resize or reposition the panes. For shared databases, also consider record locking and simultaneous edits; a split form does not prevent the normal issues that arise when multiple users work with the same records.
Split form compared with a datasheet or a regular form
A datasheet is best for viewing many rows and columns at once, sorting, filtering, and making straightforward edits. Its weakness is that each row has limited room and may require horizontal scrolling. A regular single-record form offers more control over labels, spacing, and data-entry flow, but typically requires additional navigation to move through a list of records.
A split form combines those strengths but also inherits some limitations from each view. It provides quick record browsing and a more spacious detail pane, yet the two areas compete for screen space. A continuous form is another alternative: it can show multiple records using a designed form layout, but it is not the same as Access’s built-in datasheet-and-form split. Choose based on the task, the number and width of fields, and whether users need to compare rows or follow a structured entry process.
Frequently Asked Questions
Is a split form in Access editable?
It can be, if the form permits edits and its record source is updatable. A split layout does not override read-only form settings or limitations in a query.
Do both panes show the same record?
Yes. The datasheet lists records, and the form pane displays the currently selected record in detail. Moving to a different record updates the selection shown in the other pane.
How do I create a split form in Access?
Select a table or query in the Navigation Pane, then choose Create > More Forms > Split Form. Review the result and save the form after adjusting its layout if needed.
Can I put the datasheet above the form?
Yes. In the form’s Property Sheet, find Split Form Orientation and choose the position that puts the datasheet above, below, to the left, or to the right of the form pane.
Is a split form the same as a subform?
No. A split form shows one record source in two synchronized views. A subform is a form embedded inside another form, commonly used to display related records such as the line items belonging to an order.
Related
- Hide Column Names in Power BI: What Actually Works
- Excell Battery P/N 2EXL7431-001: What It Means
- Y Balance Test: How to Perform and Calculate Scores
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- Excel CSV vs XLSX: Which File Should You Use?CSV is best for exchanging simple, plain-text data; XLSX is best for keeping an Excel workbook’s sheets, formulas,…
- Median vs Average in Excel: Which Should You Use?In Excel, use AVERAGE to calculate the arithmetic mean and MEDIAN to find the middle value in a…
- Can You Add Search to an Excel Slicer? How It WorksYes. In Excel for Microsoft 365 on Windows, click the magnifying-glass icon in a slicer’s header, type part…
- How to Verify an Excel File Has Not Been CorruptedExcel has no single command that proves a workbook is completely uncorrupted. To check a file, make a…
- VBE Editor in Windows: Name, Access, and UsesThe VBE editor in Windows is the Visual Basic Editor, commonly called the VBA Editor. It is the…
- Clear Outlook Cache: Find the Path and Remove It SafelyIn classic Outlook for Microsoft 365 on Windows, the main offline cache is usually an OST file in…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.