Have asterisks diplayed in an inputbox

[Kocheace]

Does anyone know of a way to display asterisks in an inputbox instead of the actual characters? Any help would be greatly appreciated. IT Professional

 

[beetee]

Not off hand. A non-elegant solution (which is amenable to eligization)

Creating a dialog box with an edit control that has a password input mask.

Declare a global password variable:

Public ThePassword as string

In the 'OnClose' event for the form, enter something like
ThePassword = nz(Me.PasswordControl, "&quot

To make the form look less cluttered, you should set the following properties:
ScrollBars: neither
RecordSelectors: No
Navigation Buttons: No
Dividing Lines: No

 

[Kocheace]

Thanks BeeTee but I was trying to avoid creating another form. If all else fails I will have no option but to use your suggestion. Thanks again. IT Professional

 

[combo]

You can create your own form with TextBox from Microsoft Forms Object Library 2.0. You should first make a reference to it (...\system\fm20.dll, standard VBA library, used by forms in other office applications).
This control has property PasswordChar, where you set the character apperring while writing.
Additionally, you can then use UserForm or access form.