Input Box (hide characters with astrix) REPOSTED

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

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
 
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


Diana said:
I am using an Input Box (not a control) to limit users from opening a
Click to expand...
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
Click to expand...
instance, if the password (the Input string) is made out of 5 characters, it
should show in the Input Box like this:
 
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!
Click to expand...

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.
 
Back
Top