Password Characters such as "*"

[Naveed Pathan]

hii

i want to do the follwing coding in the vba microsoft access 2003 to
generate a user password such as

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a then

[Name].enable = true
end if

where [name ] is a field contains various names
the above password do work but the problem is when i put the password like
"gul" it is visible though i want it to be hiden like asteriks or other
characters that nobody around can see it
thankx in advance

 

[Douglas J. Steele]

Check my article in Database Journal
http://www.databasejournal.com/feat...the-InputBox-function-for-MS-Access-Forms.htm

 

[John W. Vinson]

hii

i want to do the follwing coding in the vba microsoft access 2003 to
generate a user password such as

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a then

[Name].enable = true
end if

where [name ] is a field contains various names
the above password do work but the problem is when i put the password like
"gul" it is visible though i want it to be hiden like asteriks or other
characters that nobody around can see it
thankx in advance

You cannot do this in an Inputbox, but what you can do is open a small unbound
form to collect the password. Use an Input Mask property of

password

on the textbox on the form, and open the form in dialog mode.

 

[Daniel Pineault]

You can easily accomplish this by simply setting the input mask for the
password control to 'password'.

See http://office.microsoft.com/en-us/access/HP051875501033.aspx for more
information on input masks.
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

 

[Naveed Pathan]

thankx john though the rest of the people they don't try to understand the
question they just like to give the comments or the useless links to waste
the time. i am talking aobut the inputbox() and they telling me to use the
inputmax i was wondering how to get it but you made it clear it for me as
your answer is concise thankx .

hii

i want to do the follwing coding in the vba microsoft access 2003 to
generate a user password such as

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a then

[Name].enable = true
end if

where [name ] is a field contains various names
the above password do work but the problem is when i put the password like
"gul" it is visible though i want it to be hiden like asteriks or other
characters that nobody around can see it
thankx in advance

You cannot do this in an Inputbox, but what you can do is open a small unbound
form to collect the password. Use an Input Mask property of

password

on the textbox on the form, and open the form in dialog mode.

 

[Douglas J. Steele]

Did you follow the "useless link" I posted? I showed two different ways to
write your own form to accomplish what you're trying to do.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

thankx john though the rest of the people they don't try to understand the
question they just like to give the comments or the useless links to waste
the time. i am talking aobut the inputbox() and they telling me to use the
inputmax i was wondering how to get it but you made it clear it for me as
your answer is concise thankx .

hii

i want to do the follwing coding in the vba microsoft access 2003 to
generate a user password such as

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a then

[Name].enable = true
end if

where [name ] is a field contains various names
the above password do work but the problem is when i put the password
like
"gul" it is visible though i want it to be hiden like asteriks or other
characters that nobody around can see it
thankx in advance

You cannot do this in an Inputbox, but what you can do is open a small
unbound
form to collect the password. Use an Input Mask property of

password

on the textbox on the form, and open the form in dialog mode.

 

[Daniel Pineault]

Nice way to insult people trying to help you out! Had you checked out the
useless link you would had seen that for yourself.

As douglas, John and I all pointed out, input mask on a textbox control is
the way to do this. So create a simple form to collect the password and call
it instead if your inputbox. Not very hard. A simple google search would
have answered answered this question.
--
Daniel Pineault

thankx john though the rest of the people they don't try to understand the
question they just like to give the comments or the useless links to waste
the time. i am talking aobut the inputbox() and they telling me to use the
inputmax i was wondering how to get it but you made it clear it for me as
your answer is concise thankx .

hii

i want to do the follwing coding in the vba microsoft access 2003 to
generate a user password such as

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a then

[Name].enable = true
end if

where [name ] is a field contains various names
the above password do work but the problem is when i put the password like
"gul" it is visible though i want it to be hiden like asteriks or other
characters that nobody around can see it
thankx in advance

You cannot do this in an Inputbox, but what you can do is open a small unbound
form to collect the password. Use an Input Mask property of

password

on the textbox on the form, and open the form in dialog mode.

 

[John W. Vinson]

thankx john though the rest of the people they don't try to understand the
question they just like to give the comments or the useless links to waste
the time. i am talking aobut the inputbox() and they telling me to use the
inputmax i was wondering how to get it but you made it clear it for me as
your answer is concise thankx .

You're welcome... but do note that both Douglas and Daniel gave you exactly
the same suggestion, and if you had followed (and understood) the links you
would have gotten more complete and thorough help. Insulting folks who are
trying to help is impolite.

 

[Daniel Pineault]

Excellent article by the way! Once again, thank you for all your hard work
and efforts educating and helping us all!
--
Hope this helps,

Daniel Pineault
http://www.cardaconsultants.com/
For Access Tips and Examples: http://www.devhut.net
Please rate this post using the vote buttons if it was helpful.

Check my article in Database Journal
http://www.databasejournal.com/feat...the-InputBox-function-for-MS-Access-Forms.htm

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)

hii

i want to do the follwing coding in the vba microsoft access 2003 to
generate a user password such as

form_load()
dim a as string
a="gul"
if inputbox("enter your passoword") =a then

[Name].enable = true
end if

where [name ] is a field contains various names
the above password do work but the problem is when i put the password like
"gul" it is visible though i want it to be hiden like asteriks or other
characters that nobody around can see it
thankx in advance

.