i use dbf file.
When I query by insert the text in the text2 box, "DDDD" or "dddd" or "Dddd" it work because the data in the field name is "Dddd".

But When I change the data in the dbf data in the table to be like this "DDDD" or "dddd". and query again by insert the text in the text2 box, "DDDD" or "dddd" or "Dddd" . It doesn't work.

I would like the query success without ignoring its uppercase, lowercase of the data in the database.

Why I change the data in the database from "Dddd" to "DDDD" or "dddd" it doesn't work.

Code:
SearchExpression("Owner1 = '" & StrConv(Text2.Text, vbProperCase) & "' or Owner2= '" & StrConv(Text2.Text, vbProperCase) & "'")