One option would be a couple of Update Queries using the Replace()
function (assuming Access 2000 SR3 or later version). Do one query to
update YourText to...
... and another to update YourText to...
Then, if you like, you can run these Update Queries in a macro using a
couple of OpenQuery actions. If you do this, you may want to put a
SetWarnings/No action before the first OpenQuery, to supress the display
of the action query confirmation messages.
Steve Schapel, Microsoft Access MVP