0

Hello!! I have a working login/password form which reads the stored login/passwords from Access, but I am trying to make it so the login and password is case sensative?
:)
Thanks!

4
Contributors
7
Replies
8
Views
10 Years
Discussion Span
Last Post by pbrookee
0

This is what I came up with...Thanks again

If StrComp(rec!password, txtPswrd.Text, 0) <> StrComp(txtPswrd.Text, rec!password, 0) Then
MsgBox "Invalid Login and password, please try again", vbOKOnly

0

Hello!! I have a working login/password form which reads the stored login/passwords from Access, but I am trying to make it so the login and password is case sensative?
:)
Thanks!

How are you doing the comparison ?

If you are using '=' then it should be case senistive, if using 'like' then it is not case sensitive

0

Wouldn't

UCase and LCase

do...

No, UCase and LCase actually are the opposite of what he is trying to do.

0

O then just use StrConv :D

example....

Text1.Text = StrConv(Text1.Text, vbProperCase)
0

yes i am using '='

Kudos!!

How are you doing the comparison ?

If you are using '=' then it should be case senistive, if using 'like' then it is not case sensitive

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.