none
Turn Off Case Sensitivity in Table Filter RRS feed

  • Question

  • Hello:

    If I click on a table in Access 2016, it brings up a datasheet with the ability to search column contents (see example).  When I click a down arrow on the column name, it gives me options:

    Sort A to Z

    Sort A to A

    Text Filters

    If I choose text filters and enter a search value, it is case sensitive... so if I search for "abc" and the field contains "ABC" it won't find it.

    Is there a way to turn off case sensitivity for this built-in text filter feature?

    Thanks,


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Tuesday, April 9, 2019 5:22 PM

Answers

  • Hi Rich. You may have to check your settings (I'm not sure yet where) because I don't get case sensitivity when I do the same thing on my copy of A2016.
    • Marked as answer by RichLocus Tuesday, April 9, 2019 6:39 PM
    Tuesday, April 9, 2019 6:06 PM
  • That's weird. Are you really sure about this? All text operations in Access are case-insensitive by default; to perform case-sensitive text operations, you need to make it jump through hoops...

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by RichLocus Tuesday, April 9, 2019 6:39 PM
    Tuesday, April 9, 2019 6:12 PM

All replies

  • Hi Rich. You may have to check your settings (I'm not sure yet where) because I don't get case sensitivity when I do the same thing on my copy of A2016.
    • Marked as answer by RichLocus Tuesday, April 9, 2019 6:39 PM
    Tuesday, April 9, 2019 6:06 PM
  • That's weird. Are you really sure about this? All text operations in Access are case-insensitive by default; to perform case-sensitive text operations, you need to make it jump through hoops...

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    • Marked as answer by RichLocus Tuesday, April 9, 2019 6:39 PM
    Tuesday, April 9, 2019 6:12 PM
  • Hans and DBGuy:

    Good to hear from you again!  Both of you are correct.  I did the same experiment on local tables, and they are not case insensitive.

    The issue was with an ODBC connected table where the driver was written by a company called Adagio.  For whatever reason, they are case sensitive.

    When I imported it into a local table, it was case insensitive.

    Thanks,



    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Tuesday, April 9, 2019 6:42 PM
  • Oops:

    What I should have said is that LOCAL tables are case insensitive as you both expected.  ODBC connected tables using the Adagio driver ARE case SENSITIVE.


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com

    Tuesday, April 9, 2019 6:43 PM
  • Oops:

    What I should have said is that LOCAL tables are case insensitive as you both expected.  ODBC connected tables using the Adagio driver ARE case SENSITIVE.


    Rich Locus, Logicwurks, LLC

    http://www.logicwurks.com


    Hi Rich. Glad to hear you found the answer. This would be good to know for others as well. Good luck!
    Tuesday, April 9, 2019 7:01 PM