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!
pbrookee
0
Light Poster
Recommended Answers
Jump to PostDunno if it words but try using Ascii conversion.
Jump to PostHello!! 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, …
All 7 Replies
scudzilla
32
Junior Poster
Dunno if it words but try using Ascii conversion.
pbrookee
0
Light Poster
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
DenisOxon
12
Posting Whiz
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
~Paul~
7
Light Poster
Wouldn't
UCase and LCasedo...
scudzilla
32
Junior Poster
Wouldn't
UCase and LCasedo...
No, UCase and LCase actually are the opposite of what he is trying to do.
~Paul~
7
Light Poster
O then just use StrConv :D
example....
Text1.Text = StrConv(Text1.Text, vbProperCase)
pbrookee
0
Light Poster
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
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.