How do I make a condition case insensitive

[ddmcn]

I am using a series of buttons (a-z) to filter records on a form. It helps navigation to a specific record easier. What I am having a problem with is making the condition case insensitive.

Code looks like:

DoCmd.OpenForm "FRM_APPENDIX_A",,,"TERM Like 'A*'"

It will only pull up records where the TERM begins with an uppercase 'A'. Is there a way to make the condition work with both upper and lower case?

TIA

Dennis

 

[sfreeman@co.mer]

Suggestion:

Do not use the open form to filter the records.

Go ahead and open the form. If load times are an issue, open it displaying no records.

Then, on the form, have your alpha buttons a-z to filter your records.

The best example I've seen on this is in the Northwind db, on the Customer Phone List form.

 

[ddmcn]

UPDATE: Problem Solved

Thanks for the reply. I looked at the NW database and didn't see a solution.

However, I was able to filter based upon another field, an alpha designator field, that allowed me to include all the records regardless of lower or upper case.

 

[sfreeman@co.mer]

The NW Customer Phone List form has a great alpha filtering system that is very efficient. Check it out.