InputBox Formatting

[Olga Kantor]

Does anyone know how to assign a password input mask to an
InputBox object?

Thanks a lot,
Olga

 

[Rick Brandt]

Does anyone know how to assign a password input mask to an
InputBox object?

You can't. You have to design your own form to use instead of the InputBox.

Open it using the acDialog option. This causes the calling code to pause until the
form is closed.

Include a Cancel button that closes the form and an OK button that only hides it.
Either one of these cause your calling code to resume running.

You can then test to see if the form is still open (though hidden). if it is you
know they pressed [OK] and you can pull the entry they made from the form and then
close it. If the form is not open then you know they pressed [Cancel] and can drop
out of the routine.

 

[Fredg]

Olga,
You can't!!!
Make your own unbound form and add a text control.
Use the Password input mask on this control.