Member Avatar for pbrookee

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
  • 126 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by pbrookee
Member Avatar for scudzilla

Dunno if it words but try using Ascii conversion.

Member Avatar for pbrookee

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

Member Avatar for DenisOxon

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

Member Avatar for ~Paul~

Wouldn't

UCase and LCase

do...

Member Avatar for scudzilla

Wouldn't

UCase and LCase

do...

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

Member Avatar for ~Paul~

O then just use StrConv :D

example....

Text1.Text = StrConv(Text1.Text, vbProperCase)
Member Avatar for pbrookee

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.