Access Office 2003

  • Thread starter Stefan Dzurenda
  • Start date
S

Stefan Dzurenda

In my Access instalation is formule ("abcd"="ABCD") valued as TRUE. What have
I to set this value change to FALSE
 
J

Jerry Whittle

Asc("abcd")=Asc("ABCD") = False

It's cheating some as it only compares the first character of each string.
For example:
Asc("Abcd")=Asc("ABCD") = True

You might consider the StrComp function using the binary compare argument.

StrComp("abcd","ABCD",vbBinaryCompare) = 1
StrComp("ABCD","abcd",vbBinaryCompare) = -1

This means that the strings are not equal. A 0 means equal.
 
S

Stefan Dzurenda

Functions strComp(), asc() help in the specialy case, but dont help, for
example, by joining of tables, where are compared values of key fields (until
I define new help fields). Is not possible set case sensitivity in Access
2003 ?
 
S

Stefan Dzurenda

Thanks, but is not possible to set the case sensitive behaviour in Access
2003 ?
 
Top