Find Glitch?

[Slobey]

Hi,

I have a solution where I have to do finds on a description category. If I am in the field, then go into find mode and ctrl ' to set the field, I get no records found. Is there something about punctuation that makes it not work? When I modify the find and take out all punctuation, it works. It is very frustrating when you know there are records with that description.

[Lee Smith]

Are you getting any of the find characters inserted with your text (i.e. <, >, <=, >=, =, ..., !, ?, //, *, @, " ", ), that will give the punctuation worning.

Lee

[Slobey]

Many of my items have quotation marks and commas. For example one of my descriptors is [Connector, 3/4

[The Shadow]

You can script this find, and insert the value as a calculation:

"==" & Quote(yourField)

and it will find it. The Quote() escapes the double-quote for you, and adds quotes around your string. == will find only fields that match fully, leave it off and you'll get results that start like that also.

[Slobey]

Awesome! Thanks alot