password on form question!

[kidrobot]

I have this code to ask for a PW to get to the next point. When I enter the password I can see " hey! " ... is there a way to make the pw show as **** when it is being typed in?

  Dim strPassword

   strPassword = 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 strPassword = "" Or strPassword = Empty Then
       MsgBox "No Input Provided", vbInformation, "Required Data"
       Exit Sub
   End If

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

   If strPassword = "hey!" Then
   
''''''''''''''''''''''''''
do stuff
''''''''''''''''''''''''''

Else
       MsgBox "Sorry, you do not have access to this form.", vbOKOnly, "Important Information"
       Exit Sub
   End If

 

[Rabbie]

See this thread for your answer

http://www.access-programmers.co.uk/forums/showthread.php?t=132627&highlight=password

 

[kidrobot]

k from what I read it can't be done unless I create an Access password form or that API stuff, which I don't feel like doing. thanks.

 

[rainman89]

if u put a password input mask on the txtbox that they enter into they will see stars instead of the actual password

 

[kidrobot]

it isn't a textbox it is a VB input box, thanks though. Here is the API code for anyone that wants it..

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