Case Sensative (login/password)

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

Light Poster

34 posts since Apr 2007

Reputation Points: 10

Solved Threads: 0

5 Years Ago

0

Dunno if it words but try using Ascii conversion.

scudzilla

Posting Whiz in Training

275 posts since Mar 2007

Reputation Points: 27

Solved Threads: 17

5 Years Ago

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

pbrookee

Light Poster

34 posts since Apr 2007

Reputation Points: 10

Solved Threads: 0

5 Years Ago

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

DenisOxon

Posting Whiz

355 posts since Jan 2007

Reputation Points: 22

Solved Threads: 19

5 Years Ago

0

Wouldn't

UCase and LCase

do...

~Paul~

Light Poster

31 posts since May 2007

Reputation Points: 35

Solved Threads: 0

5 Years Ago

0

Wouldn't
UCase and LCase
do...

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

scudzilla

Posting Whiz in Training

275 posts since Mar 2007

Reputation Points: 27

Solved Threads: 17

5 Years Ago

0

O then just use StrConv :D

example....

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

~Paul~

Light Poster

31 posts since May 2007

Reputation Points: 35

Solved Threads: 0

5 Years Ago

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

pbrookee

Light Poster

34 posts since Apr 2007

Reputation Points: 10

Solved Threads: 0

Case Sensative (login/password)

This article has been dead for over three months