can I filter by case in access filters?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to sort a database which contains numerous entries such as "2Ad1
3aAdi" . I am trying to filter by case, e.g. show me all with A*A in them
(but not A*a). I know I can search & replace by case, but can't seem to
filter by case. Why not? Or am I missing something?
 
Access isn't case sensitive by design.

You could try something like

[MyField] Like "A*A" And StrComp([MyField], UCase([MyField]), 0) = 0

Note, though, that it'll be slow.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Filter Listview userform VBA 0
QAT & Filter By Form 1
Filter button 7
Access 2007 Filter by Form 3
Filtering Subform using option buttons on main form 3
Filter By Selection error for blank fields 2
Multiple report filter using combo box on form 2
table filter 4

Back
Top