Find And Replace Macro

[Scud121]

Is it possible to create a macro that will search 1 specific field and
replace any values found there. Specifically, I'm working on a travel
database, and whilst individual travellers are logged with a single Purpose
Of Travel code, stats are based on groups of codes. So I'd like to build a
macro to find and replace eg. POT1 with POT 1, 2, 3, 4, 5. It would also need
to replace POTS 2, 3, 4 and 5 as well.

Can this be done, and can it be made fairly idiot proof. I spent a while on
the Access Help section, buit nothing there seems to help

 

[Cheval]

hehe Sorry to laugh, but Access help is no help when you
don't know what you're looking for.

You question, Yes, create a recordset and loop through it
and use the InStr function on the field to find the text,
and replace it with what ever you want.