Find text with # not working

[KirkR]

I have a company list - when I search for "Test Company #4" it will not find it, even though the value list created from the company list includes it, AND it is visible from the list view.

However, if I change the company name to "Test Company Four" and search for it, it finds it.

What am I missing here??

[mr_vodka]

'#' is a special character for a digit wildcard. You will have to escape it out when entering the find criteria.

Test Company [color:red]#4

http://www.filemaker.com/help/03-Finding%20sorting4.html

[KirkR]

John,

Thanks - you saved me from myself again, as always......

If I had turned off auto-complete, it would find it, based on any text shy of the # sign. I knew, someplace in forgotten memory, that the # character was reserved for calculations and element naming, but did not realize that it would interfere with a simple text string find (or just not thinking -) Not worth losing the autocomplete, so maybe I'll need to filter the input field so that people won't enter such things. Wish Filemaker trapped the input like it does during development inputs.

--Kirk