Re: case sensitivity in access

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Ken Snell (kthissnellis9_at_notcomcast.realnet)
Date: 04/10/04 

Date: Sat, 10 Apr 2004 15:30:59 -0400

ACCESS does not support case sensitivity for searching/matching directly.
ACCESS treats all characters as upper case when using InStr, InStrRev, Like,
etc.

You can use the Asc() function to find specific upper or lower case
characters within a text string if you wish. In VBA you could loop through a
text string to find a lower case "a" (ASC value is 97) instead of the
generic upper case "A" (ASC value is 65). Something like this:

Dim strK As String
Dim intL As Integer
strK = "AaBbCcDd"
For intL = 1 To Len(strK)
    If Asc(Mid(strK, intL, 1)) = 97 Then MsgBox "Found it - character " &
intL
Next intL 

-- 
       Ken Snell
<MS  ACCESS MVP>
"Gary Roach" <jgroach@NOSPAMcogeco.ca> wrote in message
news:uva4hryHEHA.308@tk2msftngp13.phx.gbl...
> how do i set case sensitivity on in access? i want to search on case
> sensitive data. thanks for the help,
>
> gary
>
> -- 
> Gary Roach
> ADB Services
>
>

Relevant Pages

  • Re: Case sensitivity
    ... > So I would propose that Forth move towards lower case standard control ... > structure words, and case sensitivity. ... Rather than support the upper case words ... control structure words in upper ...
    (comp.lang.forth)
  • Re: Case sensitivity
    ... whole dimension of expressiveness, a sentiment with which I agree.) ... So I would propose that Forth move towards lower case standard control ... structure words, and case sensitivity. ... Rather than support the upper case words ...
    (comp.lang.forth)
  • Re: How to query a text string when case is in upper and lower
    ... can have combinations of upper and lower case. ... I know in SQL it's easy to ... Is there a similar way to do that in a regular Access query? ... If you want case sensitivity, or if the query is being run by SQL/Server or ...
    (microsoft.public.access.queries)
  • Re: CLisp case sensitivity
    ... >> sensitivity to case is likely coming to Lisp. ... Only the default reader setting converts everything to upper case: ... Modula-2 and Modula-3 are case sensitive and define their ...
    (comp.lang.lisp)