Modifica

Condividi tramite

TextBox.Locked property (Access)

  • Articolo

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 a TextBox object.

Remarks

The default setting of the Locked property is False. 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 textbox to only display information without allowing editing, or you might want to lock a textbox 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 textbox, 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 textbox 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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.