case sensitive user name

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.
 
D

Douglas J. Steele

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.
 
Top