Format response to msgbox as password type

N

Nigel

Is there any way to format the response to a msgbox to show as ***** instead
of what is typed in, I would like to use the msgbox as the password input as
opposed to creating a form

Thanks
 
J

Jim Burke in Novi

I'm assuming you mean InputBox, since msgbox doesn't allow user input. As far
as I know the only way to do that is by using an input mask on a textbox
control. Just create a form with the PopUp property set to true (this returns
control to the statement after the form open once the form is closed by the
user), with a text box that has the Input Mask set to Password, and an OK
button or soemthing similar for the user to indicate that they entered the
password. I have a 'global' variable that I use (this is frowned upon by
some) to keep track of whether the pw was valid or not. I open the form, and
then on the next statement after that I check the global variable to see if
they entered a valid PW .
 
N

Nigel

I am using an input box right now and I didn't want to have to use a form if
I could get away with it but thanks anyway
 
C

Chris O'C via AccessMonster.com

MsgBoxes don't allow the user to type anything. They just have a message for
the user and the user responds by pushing the ok, yes or no button or such.

You're thinking of an input box and that doesn't allow you to format the text
box or use an input mask. If you want a password input form, you need to
build a form or set the database password, or implement user level security.
The last two prompt the user when opening the db so if you want to password
protect a form or report you need to build your own password form.

Chris
Microsoft MVP
 
Top