"Staring" an input box

[Sullivan]

Hey all

I'm using Input boxes to get a username and a password
from a user to verify who they are so that they can access
only certain forms and reports. I'm wondering if there is
a way to make it so when the user types the password into
the input box to make the input be stars (like in most
applications with security) or to anything else other than
what's typed. Can anyone help?

Thanks in advance

Sullivan

 

[Rick Brandt]

Hey all

I'm using Input boxes to get a username and a password
from a user to verify who they are so that they can access
only certain forms and reports. I'm wondering if there is
a way to make it so when the user types the password into
the input box to make the input be stars (like in most
applications with security) or to anything else other than
what's typed. Can anyone help?

You have to use a form you create yourself instead of the InputBox. Then you can
give the control for the password an input mask consisting of the word "Password".

To mimic tha ability to "get the value" like an InputBox, you need to do two things.
First you need to open the form using the acDialog argument. This causes your
calling code to pause until the form you just opened is either closed or hidden.
Place [OK] and [Cancel] buttons on the form. Have the Cancel button close the form
and the OK button hide it. Then your calling code can test to see if the form is
still open. If not, you know that Cancel was pressed and you can cancel out of the
routine. If it's still open you can retrieve the password that was entered, close
the form, and then continue as before.