Microsoft Access Office VB VBA Help and Examples

Splitting Upper and Lower Case text in a Query

If you have a field that contains Uppercase and Lowercase characters and based on a character you would like to sort those fields, access sorting and grouping ignores case sensitivity.

If you would like to get case sensitivity back then simply use the expression

Asc([FieldName]) > 96
which will return true (-1) for all lowercase characters and false for all uppercase characters. 

Please note this will only look at the first character of a string of text. 

You can then use this field to group by to split up uppercase and lowercase words that are the same.

The code and application content of this site is copyright of Smiley I.T. and as such reproduction in any form which is for commercial use requires the permission of the Webmaster. Any use of this code for non-commercial use only requires a link or comment back to the original page you took the code from.