Same text comparison, two results 1

[MortenB]

I have a form with an unbound control where the user can type a search criteria. Clicking a command button will refresh a combo box which is based on a query that uses the value from the control as search criteria.

The search criteria looks like this, <.. where RefNum Like [Forms]![frmMyForm01]![ctlCriteria01] & "*">.

Then I set up the same type of search in a different form. The query in this form is different from the previoous one although the search is performed on the same field.

The search in the first form returns all hits for the the search criteria regardless case. The second performs a case sensitive search. Why the difference? I have been searching all places for "binary" or "database" options without finding anything.

 

[lupins46]

You need to post the full sql of both queries.

 

[PCLewis]

IN each forms' code window, check if you have statements in the Declarations area have any Option Compare statements.

If you do not have one, then you are using Binary for that module (form). If you do have one (and I suspect you do for one form) then it is either Text or Database because for most English locale, these are both case insensitive.

 

[MortenB]

I suppose the form's code window is the module you get when you edit any event in the form. I have checked them and they are both marked "Option Compare Database". Is there anywhere else I should look?