How to Make a Continuous Form Field Read-Only by Record in MS Access
Question details
The user needs to make a specific field in an MS Access continuous form editable for authorized records or users, but read-only for other records, without using a separate save button.
- Product
- Microsoft Access
- Device & OS
- not provided
- Scenario
- Managing data entry permissions on a record-by-record basis within a continuous form containing sensitive information.
- Observed behavior
- Setting the Locked property of a control locks it for all rows simultaneously, failing to provide independent read-only states for individual records.
Ensure you have design-level access to the database and understand basic Conditional Formatting rules before modifying form properties.
Use Conditional Formatting to Enable or Disable Controls per Record
Since locking a control via standard properties affects all rows in a continuous form, Conditional Formatting is the best method to evaluate data row-by-row and disable the control based on specific record criteria.
In Microsoft Access continuous forms, a single control acts as a template for all rows. Therefore, modifying its standard Locked property via VBA changes the state for every visible row.
Conditional formatting overcomes this limitation by dynamically applying formatting and enabled states to individual text boxes or combo boxes based on the underlying row's data.
Right-click your continuous form in the Navigation Pane and select 'Design View'.
Click on the text box or combo box that you want to make read-only for specific records.
Navigate to the 'Format' tab on the ribbon and click on 'Conditional Formatting'.
Click 'New Rule'. Under the condition dropdown, select 'Expression Is' and enter the criteria that determines if the record should be read-only (e.g., [AuthorizationLevel] <> 'Admin').
In the formatting options for the rule, click the 'Enable/Disable' toggle button (it looks like a grayed-out box) so the control becomes disabled when the condition is met. Click 'OK' to save.
Enforce Security at the Database Engine Level
Form-level formatting is not a true security boundary. You must secure the backend data to prevent users with development access from bypassing the form UI.
Looking for a Lightweight Microsoft Office Alternative?
While WPS Office does not include a database management tool like MS Access, it provides powerful, free, and lightweight alternatives for Microsoft Word, Excel, and PowerPoint. Enjoy seamless format compatibility and a familiar interface without heavy subscription fees.
- 1. Visit the Official Website: Go to the official WPS Office website to download the free installation package.
- 2. Install the Software: Run the lightweight installer and follow the quick setup instructions on your screen.
- 3. Open and Edit Your Files: Easily open your existing Word, Excel, and PowerPoint documents without worrying about formatting loss.
Frequently Asked Questions
Why does changing the Locked property via VBA affect all rows in my continuous form?
In MS Access continuous forms, a single control is repeated visually for all rows. Changing a property like 'Locked' or 'Visible' via VBA applies to the single control template, which simultaneously affects every displayed row on the form.
Can I hide a button on a specific row in an Access continuous form?
No, you cannot independently change the 'Visible' property for a single row in a continuous form. Setting it to False will hide the button for all rows. However, you can use Conditional Formatting to enable or disable text boxes or combo boxes row-by-row.
Are locked form controls sufficient to protect sensitive database information?
No, form control properties are not a complete security boundary. Users who can access the database window or Design View can easily unlock the controls. True security should be implemented using backend database permissions, compiled front-ends (ACCDE), and secure update queries.
