• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 323
  • Last Modified:

input box with passwords

I am using the following code in a onclick command of a button to pop up an input box.

I need this input box to show ****** asterisks when the person types in their password to open the form, is there anyway to do this in access 2000 and 97

here is the code that I am using


strMsg = "Please enter your password to add a part."
    strInputPassword = InputBox(Prompt:=strMsg, TITLE:="Password Required", XPos:=2000, YPos:=2000)

0
Rachy222
Asked:
Rachy222
  • 2
  • 2
  • 2
  • +2
1 Solution
 
Arthur_WoodCommented:
change the InputMask property of the TextBox to Password.
0
 
Arthur_WoodCommented:
You cannot do this using an InputBox command, however.  You will need to create your own Dialog form, to implement the Password Mask on a textbox.
0
 
nico5038Commented:
As Arthur states, this mask can't be used for an input box.
I would advise to create a function that displays a modal  pop-up form for the password (no userID required?) and that returns a boolean value (OK/NotOK) to use in your startup form's open event.

Nic;o)
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
Rachy222Author Commented:
nico,

I have never made a function like this, can you include code and more specific instructions , please ,

thanks
0
 
Suat OzgurWeb / Application DeveloperCommented:
Actually expert ameba had a link to do that in VB but i couldnot run it in VBA.

http://www.freevbcode.com/ShowCode.asp?ID=1214&NoBox=True

Related question :

http://www.experts-exchange.com/jsp/qShow.jsp?ta=visualbasic&qid=20173715

It is great way to do it in VB.

(This comment is just to share the links about Inputbox and PasswordChar.)

regards
suat
0
 
nico5038Commented:
Hi Rachel,

I dropped a form sample in your mailbox.
It's based on a value-list combobox with both userID and password.

Clear ?

Nic;o)
0
 
Ryan ChongCommented:
<listening..>
0
 
Rachy222Author Commented:
thank you very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now