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.Locked
expression Required. An expression that returns one of the objects in the Applies To list.
Remarks
The Locked property uses the following settings.
|
Setting |
Visual Basic |
Description |
|
Yes |
True |
(Default for unbound object frames) The control functions normally but doesn't allow editing, adding, or deleting data. |
|
No |
False |
(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.
Example
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
Else
Me!SalaryDetails.Enabled = False
Me!PersonalInfo.Enabled = False
Me!PersonalInfo.Locked = True
End If
End Sub
