Caps function?

[Bill]

Is there some sort of "caps function" in
Access? I use:
.....RecordsetClone.FindFirst
in performing a search looking for a match
of a given string. E.g., if MyString = "Name", I
would like a match if FindFirst encounters
the string "NAME" in the specified field.

Bill

 

[Dirk Goldgar]

Is there some sort of "caps function" in
Access? I use:
....RecordsetClone.FindFirst
in performing a search looking for a match
of a given string. E.g., if MyString = "Name", I
would like a match if FindFirst encounters
the string "NAME" in the specified field.

That happens automatically -- text searches aren't case-sensitive.
"name" will match "NAME". If you *don't* want those two to match, you
have to take additional steps.

 

[Bill]

I feel sort of dumb in that I didn't do a simple
test before I posted my question. Conditioned
thinking I guess, as we have case sensitive
comparisons on the mainframe computers.
Bill