Masking passweord input with *******

[extraolivesplea]

Am new to creating databases - just thought I'd mention that first!
I am really just practicing a few things before I start proper.
I have set up a simple password entry form where there is only 1 password for all users. It opens up another form or displays the error message. Is working fine BUT when the password is typed in you can see the word and I would prefer it to come up with *******.
Here's the code I've used - is there a way for me to mask the input with **?

Thanks

Private Sub Command4_Click()
Dim strInput As String

strInput = InputBox("Please enter password to continue", vbOKOnly, "*******")

If strInput = "inkblot" Then

DoCmd.OpenForm "teachers"


Exit Sub

End If


End Sub

 

[nickellis]

This isn't a VBA question, but if you go into the field properties and find the Input Mask section, type in PASSWORD into that property and it will do it for you.

Nick

 

[ghudson]

I am really just practicing a few things before I start proper.

You should practice searching this site for an answer to a question that has been posted in numerous threads within numerous forums on this site.

You can not format an Input Box. An Input Box is not the best tool for a programmer to use within their application.

If you had searched your question you would have found this thread which lists the answer I posted just a few days ago. Password Masking