how to put password masking in input box?

Question

4.00/5 (1 vote)

See more:

Here is the code it pops up when clicked on the button but does not accept input as password but in text format only.

VB

Private Sub Form_Open(Cancel As Integer)
Dim PassWord As String

   PassWord = InputBox("Enter password")

   If PassWord = "welcome@123" Then
      ' Open Form
      DoCmd.OpenForm "add/update tables form"
    Else
      MsgBox ("You're not authorized - now exiting")
      DoCmd.Close acForm, "add/update tables form"
      End If

      End Sub

Posted 9-Mar-11 22:59pm

execobra

Updated 9-Mar-11 23:26pm

Pravin Patil, Mumbai

v3

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Piccadilly Yum Yum · Answer 1 · 2011-03-09T23:03:00

Solution 1

Take a look there :

http://www.mrexcel.com/archive/VBA/19882a.html[^]

Posted 9-Mar-11 23:03pm

Piccadilly Yum Yum

Comments

sairam.bhat 10-Mar-11 5:42am

good ans

Maciej Los 21-Nov-11 16:09pm

Access <> Excel. Forms in MS Access are differ from these in MS Excel. Take a look at my solution.

santhoshkvijayan · Answer 2 · 2011-11-21T00:26:00

Solution 2

This might help you
TextBox1.PasswordChar = "*"

Posted 21-Nov-11 0:26am

santhoshkvijayan

Comments

Maciej Los 21-Nov-11 16:12pm

In MS Acces textBox'es have not PasswordChar property. They have Mask property, which can be set to PASSWORD.

Maciej Los · Answer 3 · 2011-11-21T10:05:00

As you said, you can't set PasswordChar for InputBox.
You need to build own userform (form in MS Access a'ka dialog window) with TextBox which can accept PasswordChar (Mask=Password). Remember to set some properties for form:
Popup = True,
Modal = True,
BorderStyle=Dialog
if you would like to have dialog-modal form (window).