Export (0) Print
Expand All

OptionGroup.Locked Property

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

Syntax

expression.Locked

expression   A variable that represents an OptionGroup object.

Remarks

The default setting of the Locked property is True. This setting allows editing, adding, and deleting data.

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, then the SalaryDetails button is enabled and the PersonalInfo control is unlocked and enabled.

Visual Basic for Applications
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


Community Additions

ADD
Show:
© 2014 Microsoft