Perhaps you should try Replace Field Contents instead of Find/Replace if you are attempting to modify a single field across all the records in your found set.
That won't work, the field contents are all different, but do have the same ending.
I don't understand why it won't work; this looks so simple. I've looked through some of my other databases and have found that I've used this script before with success. I copied one over to this script, changing the search and replace characters of course, but nothing happens. It works in the other database, not in this one.
Even when the field contents are all different, you can still use Replace Field Contents with the calculation option.
Say the field is called: YourTable::TextField and you want to change the last 3 characters of this field to YYY for every record in your table:
Show All Records
Replace Field Contents [no dialog; YourTable::TextField ; Left ( YourTable::TextField ; Length ( YourTable::TextField ) - 3 ) & "YYY" ]
Whenever you are testing Replace Field Contents, it's a very good idea to save a back up copy just before trying it out as you cannot undo.
Thank you for the help. This Replace Field Contents works. Does the trick. Also thanks for the reminder about backing it up first, turned out to be a wise move! Now it works correctly.