I DON*T WANT MY PASSWORD TO BE SHOWN..........

[OliviaS]

Hi I have this code behind a cmd button in a form:

Private Sub Label120_Click()
If InputBox("Please enter your password", "Authorization needed") = "leisure2" Then
DoCmd.RunMacro "Edit"
Else
DoCmd.RunMacro "Macro3"
Exit Sub
End If
End Sub

I want that the password, when the user enters it, will be shown as asterisks and not as the password

thanks Olivia

 

[raindrop3]

Try working with a textbox and then use the inputmask 'Password'

Raindrop

 

[OliviaS]

thanks it works =), but i want the password form to disappear after the right password has been inserted....how do i go about?

thanks for suggestions

 

[raindrop3]

Behind the password texbox, in the onChange-event enter the next code:

if
nametextbox.text = "open" then
DoCmd.Close acForm, "NAME OF YOUR FORM", acSaveYes
else
msgbox "Wrong password"
nametextbox.setfocus
end if

Greetings,

Raindrop