Astrisks out restricted form entry

[Ryan Tisserand]

I have an open form event that triggers a restricted form in vba.
strPasswd = InputBox("Enter Password", "Restricted Form")
The form is only code, not an actual form. How do I astrisks out the
password that is entered?

 

[Douglas J. Steele]

You can't. The InputBox doesn't have that capability.

You can create a form that has a text box with the appropriate Password
Input Mask, and have it pass the value back to your originating form.

 

[Ryan Tisserand]

That was my next step, i was just hoping that there was a way to change the
..InputMask = "" property on the input box. It really makes zero since to
make a restricted form then, now does it?