Text Box Only Finding Records with Exact Text

[dannybeaver]

Hi there,

I have a text box on my main form, that filters records on a subform, where its record source is a query.

The text box works okay for filtering, however it is not doing something that I would like it to.

Say we have these records

TM STEELS
TM Steels



If I was to type in STEELS, then only the top record would be displayed, likewise, if I typed in Steels, only the bottom would be displayed.

What I would like, is if you were to type steels, for example, both of the records would be displayed.

In the criteria of the field this is based on, in the query, I have:

Like "*" & [Forms]![MainWindow].[NameTxt] & "*"

As I say, this works for bringing in results that EXACTLY match the text entered in the text box, but I want it to work as explained above.

If you need any more information, please do not hesitate to ask.

Thanks everyone! D

[ranman256]

Access does not recognize case. So, STEEL = stEEl.

[dannybeaver]

hi,
thanks for the response.

If that is true, why is then that when I enter Steels, on the TM Steels record is shown, and not the TM STEELS one.

Surely if it did not recognise case, then it would return both records no?

Thanks again for the reply.

[orange]

Please post a copy of your database. Access does not recognize case unless specifically instructed/programmed to do so.

[June7]

Review:
http://support.microsoft.com/kb/98227
http://support.microsoft.com/kb/209674

[dannybeaver]

this issue is related to an sql problem, where the database has case sensitive set against it in the Collation property.