Question Find and Replace not working

[Johnrg]

I am trying to do a "find and replace" on a field in a table.

I am trying to find "#2Frame" and replace with "2 frame"

Keep getting the prompt " finished searhing records, search item not found.

No doubt something to do with the #.

Any one help on this?

Thanks

JohnG

 

[MStef]

Hello JohnG!
Do it via Update query.
Look at "DemoFindReplaceA2000.mdb" (zip).
Look at "tblJob", "Query1" (update query).
Run query.