Format response to msgbox as password type

[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

 

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

 

[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