Oddity in Text Criteria

  • Thread starter Thread starter croy
  • Start date Start date
C

croy

Using Access 2002.

In a query on a table with a Remarks field, I enter a
criteria of:

Like "*line*"

In the returns, I get a record who's Remarks field is:

Page 1: "Out of Kayaks"

A few other records are also returned that actually *do*
have the word "line" in the remarks field. The other 950
records do not get returned (expected).

If I shorten my criteria to:

Like "*ine*"

the results are the same, except a few more records properly
get returned.

If I change the criteria to:

Like "*lane*"

no records are returned (expected).

So what's the deal with "*line*"?
 
Have you checked to see if there is more text in the memo Remarks field
following a carriage return/line feed?
 
Have you checked to see if there is more text in the memo Remarks field
following a carriage return/line feed?
Click to expand...


You nailed it!

I rescinded my message, but not quicly enough, apparently.
Thanks for the effort.
 
Back
Top