Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2011
    Posts
    20

    Post Comparing Two strings issue

    Hi all

    I have a doubt in Access VBA

    I need to compare two strings with case sensitive. I have used the following code
    <Code>
    Dim str1 as string,str2 as string
    str1="ABC"
    str2="abc"
    StrComp(str1, str2, vbTextCompare)
    </Code>


    The above code return true even though the two strings are in-equilant in terms of case sensitve. I need to compare two strings with case sensitive.
    Please Suggest

    Thanks

  2. #2
    orange's Avatar
    orange is online now Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,736

  3. #3
    Join Date
    Jun 2011
    Posts
    20

    Thumbs up Re: Comparing Two strings issue

    Hi

    Thanks for your valuable suggestion

    I got my expected output

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Syntax problem? Strings
    By axess_nab in forum Forms
    Replies: 5
    Last Post: 06-01-2011, 03:21 PM
  2. connection strings in vb 2008
    By aiken_Bob in forum Programming
    Replies: 0
    Last Post: 03-14-2011, 08:25 PM
  3. Evaluating Math Strings
    By Rawb in forum Programming
    Replies: 18
    Last Post: 09-01-2010, 07:50 AM
  4. Grouping strings
    By Fre in forum Access
    Replies: 16
    Last Post: 04-24-2010, 03:46 PM
  5. Strings limited to 255 characters
    By ocordero in forum Programming
    Replies: 4
    Last Post: 08-09-2006, 09:13 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums