Those little binoculars make me mad

[mrblonde]

I'm going through a table with a few thousand records in it. I'm looking through a text column with 1 to 5 words per record. I highlight the column heading in datasheet view, click the binoculars, and I enter in my search criteria. Now I can have Johnson State Bank as one of the entries in this column. I'll type in Bank in the search box and it comes back with no records matched, (and that annoying bing) What gives? I'm at the edge of my seat with this data entry project and the search is giving me questionable results. I've got like 50 separte things to look up. What's wrong with my search method?

Thanks... this whole process is frustrating me... sorry if I come across as grouch.

 

[Bastien]

ensure that the seach crtieria is for "Any Part of Field" not "Whole field"

then it will pick up all records with the word "Bank"

hth

Bastien Bastien

There are many ways to skin this cat,
but it still tastes like chicken

 

[dannyocean]

you need to use a wild card, like in a query with like. by using just bank, Access searched for the exact string bank. Try *bank and then use find next to get what you want or better still use johnson state* and that would find the first record with johnson state xxxx in the selected column.

HTH

Danny

 

[mrblonde]

It was the whole field thing setting. Thanks amigo!