Applies to

BoundObjectFrame Object

OptionButton Object

CheckBox Object

OptionGroup Object

ComboBox Object

SubForm Object

CustomControl Object

TextBox Object

ListBox Object

ToggleButton Object

ObjectFrame Object

The Locked property specifies whether you can edit data in a control in Form view. Read/write Boolean.


expression Required. An expression that returns one of the objects in the Applies To list.


The Locked property uses the following settings.


Visual Basic




(Default for unbound object frames) The control functions normally but doesn't allow editing, adding, or deleting data.



(Default for all controls except unbound object frames) The control functions normally and allows editing, adding, and deleting data.

You can set these properties by using a form's property sheet, a macro, or Visual Basic for Applications (VBA) code.

Use the Locked property to protect data in a field by making it read-only. For example, you might want a control to only display information without allowing editing, or you might want to lock a control until a specific condition is met.


The following example toggles the Enabled property of a command button and the Enabled and Locked properties of a control, depending on the type of employee displayed in the current record. If the employee is a manager, the SalaryDetails button is enabled and the PersonalInfo control is unlocked and enabled.

Sub Form_Current()
If Me!EmployeeType = "Manager" Then
Me!SalaryDetails.Enabled = True
Me!PersonalInfo.Enabled = True
Me!PersonalInfo.Locked = False
Me!SalaryDetails.Enabled = False
Me!PersonalInfo.Enabled = False
Me!PersonalInfo.Locked = True
End If
End Sub

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!