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 ?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word macro that can call cells out of Excel for a find and replace 0
SUM Char 9
Extracting the last word from a string. 2
VLookup and text strings 3
report in access (Count) 2
Text Fields changing case 2
How to overwrite data in file? 0
How to adjust numbers in Outline 0

Top