Finding too many records

[steveob]

I have a field named "Regions" in which there is one region named "South England" and another "SW England and South Wales". When I do a find on "South England", the find is returning both regions, presumably because the word "South" is in both. Is there a way of finding only exact matches? I had presumed that the find would only find the region which begins with "South". I have solved it temporarily by changing "SW England and South Wales" to "SW England and S Wales" but would prefer to go back to the original if possible. Any advice much appreciated.

[-Queue-]

You can either put it in quotes or add == in front of it.

[QuinTech]

Use quotes in the search. "South England" instead of South England.

HTH,

Jerry

[QuinTech]

JINX!

[-Queue-]

That used to be my nickname. Don't take it in vain!

[steveob]

Thanks for the replies. The field is a drop down box from which I select "South England" etc. As this field is transferred to other layouts, I do not want it to have "Quotes" automatically. When I do the find, I cannot seem to insert the quotation marks after selecting the region from the drop down box. Have tried to right click and cut and then type in "South England" with quotes but that does not work.

Could I introduce another region, "South England" with the quotes, purely for find purposes or would that affect the other layouts?

Any more suggestions gratefully received.

Steveob

[-Queue-]

Assuming you are using a scripted find,

Set Error Capture [On]

Enter Find Mode [Pause]

If [not IsEmpty(Region)]

Set Field [Region, "==" & Region]

Perform Find [Replace Found Set]

If [not Status(CurrentFoundCount)]

Show Custom Dialog ["There are no records with that criteria."]

End If

[steveob]

Thanks for all the replies. I tried my own suggestion in my previous post and added another region with inverted commas, purely for doing finds Used this for the find and all went perfectly. Thanks for the sample script Carpal Tunnel, I'm sure it would have worked!

Until the next time, thanks again everyone.

Steveob