inputbox: when input, ****** ? How to make?

  • Thread starter Thread starter Martin
  • Start date Start date
M

Martin

How to make INPUTBOX ******, when the users entering the password?

For example, how to change the VBA sentences as follows, to achieve ******
input condition


Private Sub Form_Open(Cancel As Integer)
Dim hold As Variant

hold = InputBox("please input password", "HELLO")
If hold <> "abcd" Then
MsgBox "PASSWORD IS WRONG", , "HELLO"
DoCmd.Close

Else
Exit Sub
End If

Exit Sub
End Sub


Thank you.
 
Martin said:
How to make INPUTBOX ******, when the users entering the password?

For example, how to change the VBA sentences as follows, to achieve
****** input condition


Private Sub Form_Open(Cancel As Integer)
Dim hold As Variant

hold = InputBox("please input password", "HELLO")
If hold <> "abcd" Then
MsgBox "PASSWORD IS WRONG", , "HELLO"
DoCmd.Close

Else
Exit Sub
End If

Exit Sub
End Sub


Thank you.

The InputBox function doesn't provide a password-masking feature. You
can use your own dialog form instead.
 
Back
Top