asked on

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)

Arthur_Wood

change the InputMask property of the TextBox to Password.

Arthur_Wood

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.

nico5038

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)

Rachy222

ASKER

nico,

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

thanks

Suat M. Ozgur

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 :

https://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

ASKER CERTIFIED SOLUTION

nico5038

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Ryan Chong

<listening..>

Rachy222

ASKER

thank you very much