Results 1 to 4 of 4

Thread: case-sensitive

  1. #1
    Join Date
    Nov 2006
    Posts
    43

    Unanswered: case-sensitive

    I've been trying to find a way to make access case-sensitive. in one of my tables I have a Aw and a AW. is there any way I can make it so they both don't look the same in access

  2. #2
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    As I said

    Quote Originally Posted by missinglinq
    at the top of the code module for any Form or Report.
    In Design View for the Form or Report, click on Design on the Ribbon, then click on View Code. AT the very top you'll see Option Compare Database.

    Linq ;0)>
    Last edited by Missinglinq; 11-04-15 at 21:33.
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  3. #3
    Join Date
    Nov 2006
    Posts
    43
    Where would I enter
    Option Compare Database

    with

    Option Compare Binary

  4. #4
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    as the first line of each and every module (be that form,. report or stand alone code module) in that modules code window
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •