November 12, 200421 yr 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.
November 12, 200421 yr Are you getting any of the find characters inserted with your text (i.e. <, >, <=, >=, =, ..., !, ?, //, *, @, " ", ), that will give the punctuation worning. Lee
November 29, 200421 yr Author Many of my items have quotation marks and commas. For example one of my descriptors is [Connector, 3/4
November 30, 200421 yr 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.
Create an account or sign in to comment