How to Make Form Read Only MS Access

Updated on:

April 6, 2026

By:

Use this interactive demo to learn how to make a form read-only in Microsoft Access.

‍

To make a form read-only in Microsoft Access, you can configure its properties to prevent users from adding, editing, or deleting records. Here are several methods to achieve this:

‍

Open your desired database.
Open the Form in Design View. In the Navigation Pane, right-click the form and select 'Design View'.
Click 'Property Sheet' in the 'Form Design' tab.
Go to the 'Data' tab in the Property Sheet.
Set the following properties as 'NO' such as 'Data Entry', 'Allow Additions', 'Allow Deletions' and 'Allow Edits'.
Save the form by clicking 'Save' in the 'Navigation Pane'.

📌 Why this matters

Making forms read-only transforms your database into a secure information display system, perfect for dashboards, reports, or reference materials that users need to view but shouldn't modify. Beyond basic data protection, read-only forms create audit-friendly environments where you can confidently share sensitive information with stakeholders without worrying about accidental changes.

This approach also helps you maintain separate workflows—users can browse historical records or reference data through read-only forms while authorized personnel handle data entry through dedicated input forms.

Your product deserves an interactive demo

Start free

How to Integrate a Microsoft Excel Database with Excel

How to Integrate Google Calendar with an MS Access Database

How to Integrate Google Sheets with an MS Access Database