Password protected form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do I add a password protected form? I don't want to set up user
accounts, I just want to add a password to enter a specific form. Can it be
done???
 
How do I add a password protected form? I don't want to set up user
accounts, I just want to add a password to enter a specific form.
Can it be done???

In the OpenEvent of the form...

If InputBox("Enter Password") <> "YourPassword" Then
MsgBox "Wrong Password"
Cancel = True
End If

If you are not distributing as an MDE then anyone will be able to go into
design view and see the password though. Also there is no way to get a
password mask (asterisks) with an InputBox().
 
Back
Top