Find and Replace in a Macro

[susanmgarrett]

I have a field which must be checked monthly for characters. Right now I'm using Find and replace, but I'd like to automate it using a macro.

For example, the filed contains the following text string:
Banging and boppin’, hip-hop with a “street” feel; percussion

I need to remove the MS specific curly characters and the semi-colon and replace them as follows:
Banging and boppin', hip-hop with a 'street' feel - percussion

I can't use update because it will update the entire field. What actions can I use in a macro that (once having opened a query or table that contains the field), will search and replace all instances of a specific character in that field?

Thanks for the assist.