Input Box (hide characters with astrix) REPOSTED

[Guest]

I am using an Input Box (not a control) to limit users from opening a certain form once they click on a Command button

I am wondering if there is any way I can hide what the user types. For instance, if the password (the Input string) is made out of 5 characters, it should show in the Input Box like this

****

THANK YOU FOR YOUR HELP

 

[Cheryl Fischer]

Diana,

The InputBox does not have the capability of using a mask. What you will
need to do is create a form which asks the user to input the password into a
textbox which has a password mask.

hth,

--

Cheryl Fischer, MVP Microsoft Access
Law/Sys Associates, Houston, TX

I am using an Input Box (not a control) to limit users from opening a

certain form once they click on a Command button.

I am wondering if there is any way I can hide what the user types. For

instance, if the password (the Input string) is made out of 5 characters, it
should show in the Input Box like this:

 

[fredg]

I am using an Input Box (not a control) to limit users from opening a certain form once they click on a Command button.

I am wondering if there is any way I can hide what the user types. For instance, if the password (the Input string) is made out of 5 characters, it should show in the Input Box like this:

*****

THANK YOU FOR YOUR HELP!

Sorry, not possible using an InputBox.

The work-around is to make your own unbound form.
Add an unbound control.
Set the InputMask property of the control to 'Password'.
Add a command button.
Set it's Click event to:
Me.Visible = False

Then, where ever you now are using:
strX = InputBox("etc")
If strX = etc.
You would use:

DoCmd.OpenForm "FormName", , , , , acDialog
strX = forms!FormName!ControlName
DoCmd.Close acForm,"FormName"
if strX = etc.