Password

[hnhpak]

Re: https://www.accessforums.net/forms/c...orm-34171.html



Thanks for publish this simple code which can help millions of peoples, God Bless you.

I will be grateful to you if you could also guide how can we hide the password from screen on typing so that it shows only ******* instead of actual password.

Regads Haseeb

[June7]

Use Input Mask property. Select the password mask. This can be set up directly in table or just in textbox on form.

[hnhpak]

Use Input Mask property. Select the password mask. This can be set up directly in table or just in textbox on form.

Thanks June7,

I am using InputBox instead of using textbox on form, my code is as under as you mentioned in this thread.

Private Sub Form_Open(Cancel As Integer)
If InputBox("What is the Password?") <> "TC" Then
MsgBox "Nice Try Wise Guy, You're Out!!"
Cancel = True
End If
End Sub

so will you please guide how can I change the properties of InputBox further it accept both uppercase and lower case characters in password can't differentiate between them.

Thanks and regards

Haseeb ul Hasan

[June7]

Sorry, cannot change properties of InputBox. Access is by default not case sensitive. Enforcing case sensitivity is not something I've ever done. Would probably require a bunch of VBA code to validate each character of the password string. Suggest you search the web on topic of case sensitivity in Access.

[hnhpak]

Sorry, cannot change properties of InputBox. Access is by default not case sensitive. Enforcing case sensitivity is not something I've ever done. Would probably require a bunch of VBA code to validate each character of the password string. Suggest you search the web on topic of case sensitivity in Access.

Thanks June7 for your suggestions. This i am using for just one subform of navigation form which have command buttons for administrator use only.

By the way do you have any link or sample database for login ID and password which can keep records of login and protect database by password?

[June7]

Common topic in forum. Suggest you search.

I have never done password protection. It is hard to truly secure an Access database. Any competent user knows just to hold down shift key while opening db to bypass code execution.