Entering Password using Inputbox

[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

 

[Douglas J. Steele]

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

 

[KimTong via AccessMonster.com]

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,

[quoted text clipped - 6 lines]

KT

 

[Douglas J. Steele]

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!)

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,

[quoted text clipped - 6 lines]

KT

 

[KimTong via AccessMonster.com]

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:

[quoted text clipped - 24 lines]

 

[J_Goddard via AccessMonster.com]

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.

[quoted text clipped - 5 lines]