----- Hide Password in Input Box -----

[alhabkk]

This should be an easy one but I am not 100% sure how to do it.

I have written the following code on a command button to set up a basic password for deleting current record. What I really want to do is hide the password being typed into the input box with asterix's. Here is the current code and password:

Private Sub Toggle33_Click()
Dim strPasswd
strPasswd = InputBox("Enter Password", "Restricted Form")
If strPasswd = "" Or strPasswd = Empty Then
MsgBox "No Input Provided", vbInformation, "Required Data"
Exit Sub
End If

If strPasswd = "Oxy123" Then
DoCmd.RunCommand acCmdDeleteRecord
Else
MsgBox "Sorry, you do not have access to delete record", _
vbOKOnly, "Important Information"
Exit Sub
End If
End Sub

 

[pbaldy]

It's a little involved:

http://www.access-programmers.co.uk/forums/showthread.php?t=150644

I use a form:

http://www.baldyweb.com/WrappedForm.htm

 

[alhabkk]

its too complicated..there is easier way..!

 

[pbaldy]

I'd be interested to see it.

 

[alhabkk]

I'd be interested to see it.

sir,
in my issue, what i have do? create form? then....?
thanks

 

[pbaldy]

Like I said, I use the form in the link since it can be used from anywhere.