Distinguish between upper case and lower case

J

Johnny Romper

I have a list of two character codes. For example, Fx and fx. How do I make
access treat these codes as unique?
 
K

Ken Snell [MVP]

Jet database engine does not differentiate based on case; neither does
ACCESS VBA. What you seek to do could be very dangerous unless you always
remember to use your own comparison routines everywhere in the database!

That said, check out the StrCompare function (see Help file).
 

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

Lower-Case Characters 2
changing lower to upper case issue 1
Two columns followed by single page-width column on same page 0
Convert list to UPPER, lower & Proper cases. 21
upper case lower case 0
(Word 2016/365) Removing white space between pages at a smaller zoom 0
VBA word change keys 0
Closing PDF file from Excel VBA (Adobe Reader, Adobe Acrobat, Browser) 0

Top