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.
 

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

Similar Threads

Oversensitive touchpad on modern laptops 0
case-sensitive primary keys 10
Case sensitive password 1
Sensitivity analysis 5
Check for VPN Connection 4
Password case sensitivity in a form 7
Making .FindFirst Case-Sensitive 4
Case sensitive query 19

Back
Top