About capitalization

realar

New member
Local time
Yesterday, 21:58
Joined
Nov 26, 2009
Messages
3
Access cant identify the distinction between "A" and "a".
But I need the funtion that do different work with "a" and "A".

How can I do? Is there a switch or a button can be used in Access2007 to make the system distinguish the capitalization and lowercase letter ?

Thank u!
 
At the module level: -

Option Compare Text
Option Compare Binary

At the procedure level: -

MsgBox StrComp("ABC", "AbC", vbTextCompare)
MsgBox StrComp("ABC", "AbC", vbBinaryCompare)
 

Users who are viewing this thread

Back
Top Bottom