case sensitive user name

  • Thread starter Thread starter eighthman11
  • Start date Start date
E

eighthman11

Hello everyone. Using Access 2003. Quick question.

I have an application that makes the user sign in with a user name and
password. The sign in for the user name is not case sensitive. Is
there a way to make the user name case sensitive for the sign in.

Any help appreciated. Thanks Ray.
 
You can use the StrComp function, with the (optional) third parameter
(Compare) set to vbBinaryCompare (which is equal to 0).

StrComp("eighthman11", "Eighthman11", vbBinaryCompare) will return 1,
StrComp("Eighthman11", "eighthman11", vbBinaryCompare) will return -1, while
only StrComp("eighthman11", "eighthman11", vbBinaryCompare) will return 0,
indicating they're the exact same.
 
Back
Top