We help IT Professionals succeed at work.

Hide Password (*****) in access

namlig
namlig asked
on
1,093 Views
Last Modified: 2012-05-05
Buidling database for multiple users.  Used VB Code to create passwords to protect certain areas.  When the password is typed, it shows the letters that are being typed.  What is the code to hide the password as it is being typed, i.e. ***.
Comment
Watch Question

Commented:
Define the field in the table with for the Input mask: Password

Now it will show always as *****

Nic;o)
CERTIFIED EXPERT

Commented:
Put the word "password" in the input mask.

Author

Commented:
I will not be able to try these solutions until I return to the office on Tuesday 2/21. it sounds as though this is the solution since there are two alike.

Commented:
I used it many times. When you place the cursor in the Input Mask field you'll see a [...] button appear at the end.
Pressing that will show a number of available masks, including the password.
On that form you can test the mask when needed.

Nic;o)

Author

Commented:
Currently we are use the following example of VB Code to bring up the various password input boxes for password entry. There is no way to just add the input mask. Do you know the VB Code that needs to be added to hide the password as it is entered? Point level has been incresed to 500.

Private Sub cmdCOForm_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)

'Attached to On Click event of cmdCOForm

    Dim strPasswd

    strPasswd = InputBox("Enter Password", "Restricted Form")

    'Check to see if there is any entry made to input box, or if
    'cancel button is pressed. If no entry made then exit sub.

    If strPasswd = "" Or strPasswd = Empty Then
        MsgBox "No Input Provided", vbInformation, "Required Data"
        Exit Sub
    End If

    'If correct password is entered open CO form
    'If incorrect password entered give message and exit sub

    If strPasswd = "officer" Then
        DoCmd.OpenForm "CO", acNormal
    Else
        MsgBox "Sorry, you do not have access to this form", vbOKOnly, "Important Information"
        Exit Sub
    End If
End Sub
Commented:
This one is on us!
(Get your first solution completely free - no credit card required)
UNLOCK SOLUTION
Unlock the solution to this question.
Join our community and discover your potential

Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.