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

Similar Threads

Microsoft 365 Activations, Users or Devices? 0
Cannot Change Back to Previous Settings After Clicking "Try the new Outlook" 0
Office 365 Email Encryption One time Passcode 0
Incorporating the User Profile location into a document template path 1
Drop down list control value in vba 2
Word Template where user inputs <TITLE> and then that can be displayed in footers or headers [MAC] 0
upper case - lower case issues - dropdown box is case sensitive??? 0
Sharepoint not capturing staff name when automation runs 0

Top