How to make Access differentiate capital letter "A" and normol letter "a" in que

  • Thread starter Thread starter Thinh Nguyen
  • Start date Start date
T

Thinh Nguyen

Hi all,
In my table, I used some letters in Capital and normal
form. Then when I used the letters as parameters in a
query, I found out Access cannot differentiate "A"
and "a". Can anybody help me with this.
Many thanks
 
StrComp("A", "a", vbBinaryCompare) or StrComp("A", "a", 0) returns -1, while
StrComp("A", "a", vbTextCompare) or StrComp("A", "a", 1) returns 0.
 
You could also set the ascii equivalent and see if its above or below a capital
number range. Or see if the letter = ucase(letter)
If not, it's lower case

(e-mail address removed)
 
Back
Top