Password textbox

[John liem]

I have created a button which will open up a password inputbox where I can type a password and enable some of other buttons to run certain reports.
How can I make my input invisible (*****) when typing the password?.
Thanks in advance, John

 

[Mile-O]

In the InputMask property write Password.

 

[John liem]

Password inputbox

Hi Mile,

This is what I have written to open up the InputBox

Private Sub PW_Click()
Dim x As String
x = InputBox("PASSWORD:", "Run Report")
If x = "drowssap" Then Button63.Enabled = True
End Sub

Where do I have to add your suggestion?
J.

 

[Mile-O]

Sorry, I didn't realise you were using an InputBox for this. Using an InputBox you can't format it so.

That's where a form comes in handy. Placing a textbox on a form* and setting the InputMask property of the textbox to Password is the better practice.

Underneath the textbox you can put the command buttons you deem necessary such as Login. The command button can then check that the textbox has something typed into it and also verify the password.

* The form works/looks best when it's Modal and PopUp properties are set to Yes.

 

[John liem]

Hi Miles,

I did change the InputBox using as a form and it works fine ...
Thanks,
J