asterix instead of letters in inputbox

[irade92]

Hi
I use InputBox to enter password. How to type asterics instead of letters in Inputbox....Thanks

 

[tobyjenkins]

Hi

Two options without using any VBA (assuming you don't want to):

1. IF your form is BOUND to its data source then in the table holding the information, you can set that field's Entry format to password - this should cover the text with ****s

2. If you're using an UNBOUND form, you can set the InputMask property of the text box to password.

Just as an aside - I read an article recently (don't ask where) calling into question how useful password masks actually are as most users tend to make sure they're not being watched while they type their password anyway and I know myself (in agreement with the article) that when you are trying to type a particularly obtuse password it's actually pretty handy to be able to see what you're typing.

If you wanted to, a third option would be to write a script that allows each character to de displayed momentarily before being replace with a * (or perhaps a bullet character)...

Toby

 

[gemma-the-husky]

the thing is, you cannot set an input mask with INPUTBOX - so you have to roll your own password form.