I just typed 1/23 into a text field.
When I enter find mode and type in 1/23, it finds that record. So I am not able to reproduce this.
That recent crash could have damaged your file or just screwed up an index or two.
You might try using recover's advanced settings to re-index all of your fields and then see if the copy with rebuilt indexes still shows this behavior.
If you have FileMaker 11 or newer, you can use Advanced Recovery options to rebuild your file's indexes:
- With the file closed, select Recover from the File Menu.
- Select "Use advanced Options"
- Select only: "Copy File Blocks as-is" and "Rebuild Field Indexes Now".
Thank you for your response! I tried the recovery and no change in the behavior. This is a shared database, could text inputed from different computers have different formatting or encoding that prevents it from being findable from other computers?
What happens if you create a new, one-field database with just a text field in it, enter that sample data and see if the Find works? And if you share it, and the other users enter the same data?