Others

How to Create a Microsoft Access Form That Displays Multiple Records

Huda Qurayshi Oct 9, 2026 869 views

Question details

The user wants to create a form in Microsoft Access that allows them to view and manage multiple records at the same time rather than viewing a single record per page.

How to Create an Access Form That Displays Multiple Records

Product: Microsoft Access
Device & OS: not provided
Scenario: Reviewing or managing large sets of database records where a single-record form layout is too slow or inefficient for data entry and comparison.
Observed behavior: The user needs a tabular or datasheet layout for the form, but sometimes encounters an issue where the displayed columns and fields are not editable.

Before you start

Ensure that the underlying table or query you plan to use as the record source is fully updateable, as this determines whether you will be able to edit the records within your new form.

Solution 1Recommended

Use the Multiple Items Form Tool

This is the most efficient way to generate a customizable, continuous form layout that displays multiple records in structured rows.

The Multiple Items tool automatically builds a tabular layout. While it displays data much like a spreadsheet, it gives you the full design flexibility of a standard Access form.

Select the data source

Open the Navigation Pane on the left side of your Access database and click on the table or query you want to use as the foundation for your form.

Navigate to the Create tab

Click on the 'Create' tab located on the top ribbon menu.

Generate the Multiple Items form

In the Forms group, click on 'More Forms' and select 'Multiple Items' from the dropdown menu. Access will instantly generate a tabular form.

Customize the layout

Switch to 'Design View' or 'Layout View' by right-clicking the form tab. Here, you can adjust column widths, change field headings, and apply visual themes.

Why are my fields not editable?: If you cannot edit the records in Form View, your underlying query may not be updateable. Queries using aggregate functions, DISTINCT clauses, or complex multi-table joins without proper primary keys will render the resulting form read-only.

Solution 2

Create a Datasheet View Form

Use the Datasheet view if you prefer a straightforward, raw grid layout that looks and acts exactly like an underlying table or query.

Free Microsoft Office alternative

Manage Your Data Efficiently with WPS Office

While Microsoft Access is built for complex relational databases, many users only need to manage lists, flat-file databases, and multiple records. WPS Spreadsheet provides a lightweight, free, and highly compatible alternative to Microsoft Office for organizing and analyzing large datasets without the steep learning curve of a dedicated database program.

1. Download the installer: Visit the official WPS Office website and click the free download button for your operating system.
2. Install WPS Office: Run the downloaded installer and follow the on-screen instructions to complete the setup.
3. Open WPS Spreadsheet: Launch WPS Office and select Spreadsheet to start managing your data records easily.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv) for seamless data sharing and management.Lightweight architecture ensures smooth performance even on older devices and operating systems.Built-in advanced filtering, data validation, and PivotTables to easily view and manipulate multiple records at once.Familiar user interface means zero learning curve for users switching from Microsoft Office.

microsoft office alternative - wps office

Frequently Asked Questions

Can I change an existing single-record form to display multiple records?

Yes. Open your existing form in Design View, press F4 to open the Property Sheet, select 'Form' from the selection type dropdown, and change the 'Default View' property from 'Single Form' to 'Continuous Forms' or 'Datasheet'.

What is the difference between Tabular layout and Datasheet view in Access?

Datasheet view looks exactly like a standard Excel spreadsheet or Access table, offering limited design flexibility. The Tabular layout (Multiple Items form) places records in continuous rows but allows you to fully customize fonts, colors, add command buttons, and adjust field sizes using Design View.

How do I fix an Access form where the data cannot be edited?

Form editability is strictly controlled by the record source. Open the underlying query in Datasheet view; if you cannot add or edit records there, you won't be able to in the form either. Ensure your tables have primary keys defined and that your query relationships are properly established.

Office Quick Solutions