Password Protected Form

[Ms Kathy]

I have a password protected form that works fine. However, when you type in the password it can be seen on the screen. Is there a way I can change that so that when the password is typed in it can't be read (perhaps showing asterisks)?

This is what I'm using:

In ON CLICK event
Dim PassWord As String
PassWord = InputBox("Enter Password")
If PassWord = "MYPassword" Then
' Open Form
DoCmd.OpenForm "MYFormName"
DoCmd.GoToRecord , , acNewRec
Else
MsgBox ("You're not authorized")
End If


Thank you kindly!

 

[CJ_London]

settimg the controls input mask in the data tab to password will display asterisks.

another alternative, tho' not so good is to se the forecolor to the same as the back color

 

[Ms Kathy]

I'm not sure I follow. (I'm a novice.)

This was created using a Form Control Button, On Click - Event Procedure.

I'm looking in the properties of the button and do not find "input mask". Where would I find this?

Thank you.

 

[CJ_London]

you say

However, when you type in the password it can be seen on the screen

I'm assuming this was typed into a control on a form and is not an inputbox.

In design view of the form where you enter the password, select the control where you type in the password, right click and select properties then click on the data tab. The input mask property is about the 3rd item down

 

[Ms Kathy]

The problem I seem to be having is that I cannot locate the properties of the Message Box.

The Control Button is on a form that contains many other control buttons that enable the users to get what they need (print preview reports, enter data, etc.)

This particular Control Button, when clicked, enables an Event Procedure (listed in original post) that asks for the password in a message box. It is this message box of which I have been trying to find the properties. I am unable to get to a "design view" of it; nor can I locate it anywhere else in the database.

Thank you again for your responses.

 

[CJ_London]

It sounds like you are using an inputbox (not a msgbox) to input your password. If this is the case you cannot access the properties.

Just to double check, can you post the code behind your control button. It may be you can create your own input box - being a single form designed to look like an inputbox and with its modal and pop up properties set to true.

 

[Ms Kathy]

I sincerely appreciate your input; however, this is getting too complicated for me to follow. Thank you again and have a most wonderful day.