Distinguish between upper case and lower case

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list of two character codes. For example, Fx and fx. How do I make
access treat these codes as unique?
 
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).
 
Back
Top