We help IT Professionals succeed at work.

Hide Password (*****) in access

namlig asked
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. ***.
Watch Question

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

Now it will show always as *****


Put the word "password" in the input mask.


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.

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.



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
        MsgBox "Sorry, you do not have access to this form", vbOKOnly, "Important Information"
        Exit Sub
    End If
End Sub
This one is on us!
(Get your first solution completely free - no credit card required)
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.


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.