Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

changing input mask format with code 1

Status
Not open for further replies.

TheunsGoosen

Technical User
Jan 17, 2007
36
GB
Access beginner,
Hi,
Im using code to unlock information so the user can change the information. I also need the input mask to change from "password" to "text", but im struggling with that specific part of the code.
Thanks
Theuns

Private Sub EmployeeCode_Enter()
Dim strInput As String, strMsg As String

strMsg = "'Action code'is password protected."
strInput = InputBox(prompt:=strMsg, _
Title:="Emplyee 'action code'")
If strInput = "CLR" Then
Me.EmployeeCode.Locked = False
'Me.EmployeeCode.InputMask = text
'InputMask = password
Else
Me.EmployeeCode.Locked = True

End If
 
Plain text does not need a mask:

[tt]Me.EmployeeCode.InputMask = ""[/tt]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top