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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top