Find and Replace in a Macro

[susanmgarrett]

I have a field which must be checked monthly for characters. Right now I'm using menu Find and Replace with a query, but I'd like to automate the task using a macro.

For example, the field 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 an update query 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.

 

[KeithG]

You will probably have to use the replace function in VBA.