Query with an input mask [Password]

[Reppihsrow]

How can I do a query that if it is ask and I type, it willl be shown as ******* and not a text. thanks for your help. I am a new user in Access 2007.

 

[John Big Booty]

You can use;

    If CBool(InStrB(Me.Password, Me.Password2)) Then
        MsgBox "Congratulations your Passwords match"
    Else
        MsgBox "Epic Fail"
    End If

 

[Reppihsrow]

You can use;

    If CBool(InStrB(Me.Password, Me.Password2)) Then
        MsgBox "Congratulations your Passwords match"
    Else
        MsgBox "Epic Fail"
    End If

- But where I will put that in a simple query?

 

[John Big Booty]

You would need to put that in a Command Button Click Event or other form control event.

 

[gaccess]

hi maybe if it is just to hide the input in your password text box
In Design View click your password text box choose properties choose Data choose Input Mask choose Password then your entries will be ****** don't forget your password

 

[Reppihsrow]

hi maybe if it is just to hide the input in your password text box
In Design View click your password text box choose properties choose Data choose Input Mask choose Password then your entries will be ****** don't forget your password

- this is the first thing that I did. But it changes nothing in the query. I don't know why.

 

[John Big Booty]

Have a look at the code behind the On Click event of Command8, in the attached sample.