Locked Property

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
Share Facebook Facebook Twitter Twitter Email Email

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×