Entering Password using Inputbox

  • Thread starter Thread starter KimTong via AccessMonster.com
  • Start date Start date
K

KimTong via AccessMonster.com

Hi all,

I use an Inputbox VB script to enter a password on my form. I'd like when
user enter the password, only '*' comes up on the screen so nobody can see it.
Is anyone have an idea how to do that using InputBox statement?

Thanks in Advance.

KT
 
I tried to use Input Mask on text box Form named: 'Passw'. And after update
event, I wrote VB script like this:

Dim Password As String
Password = Me.Passw
Do Until Password = "Roger"
DoCmd.OpenForm "PasswForm"
Password = Me.Passw
Loop

When I put the correct password, it went thru. But when I tried to enter the
wrong password, the message says "The expression you entered refers
to an object that it closed or doesn't exist'

Do you have any ideas to fix that?
The InputBox doesn't have that capability.

Take a look at my March, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/smartaccess.html
Hi all,
Click to expand...
[quoted text clipped - 6 lines]
KT
Click to expand...
Click to expand...
 
Afraid I can't comment, as you've given too little information.

Did you try the approach in the article I cited? I know that works.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


KimTong via AccessMonster.com said:
I tried to use Input Mask on text box Form named: 'Passw'. And after update
event, I wrote VB script like this:

Dim Password As String
Password = Me.Passw
Do Until Password = "Roger"
DoCmd.OpenForm "PasswForm"
Password = Me.Passw
Loop

When I put the correct password, it went thru. But when I tried to enter
the
wrong password, the message says "The expression you entered refers
to an object that it closed or doesn't exist'

Do you have any ideas to fix that?
The InputBox doesn't have that capability.

Take a look at my March, 2005 "Access Answers" column in Pinnacle
Publication's "Smart Access". You can download the column (and sample
database) for free at http://www.accessmvp.com/djsteele/smartaccess.html
Hi all,
Click to expand...
[quoted text clipped - 6 lines]
KT
Click to expand...
Click to expand...
Click to expand...
 
Hi Douglas,

I saw it, but I didn't see the input Mask that I want. I still can see the
character that we enter on Input Mask.

KT
Afraid I can't comment, as you've given too little information.

Did you try the approach in the article I cited? I know that works.
I tried to use Input Mask on text box Form named: 'Passw'. And after update
event, I wrote VB script like this:
Click to expand...
[quoted text clipped - 24 lines]
Click to expand...
 
Did you set the Input Mask property of the textbox to "Password" (no quotes)?
That will display only *** in the textbox, with the value entered still being
accessible in your code.

John

Hi Douglas,

I saw it, but I didn't see the input Mask that I want. I still can see the
character that we enter on Input Mask.

KT
Afraid I can't comment, as you've given too little information.
Click to expand...
[quoted text clipped - 5 lines]
Click to expand...
 
Back
Top