K
kev100 via AccessMonster.com
I've got a field with several 100 characters. The exact composition of those
characters vary.
However, in all records, a certain exact phrase will always be present.
I'm needing to replace that phrase with another while keeping the rest of the
text the same.
Currently....I open the entire table...go to that field, and perform a
Find&Replace on that field using the "any part of field" match option. I
type the current phase into the Find What field and the new phrase into the
Replace With field.
This works fine and replaces all instances of that phrase.
I'd like to...if possible....use a parameter update query to do this so that
the replacement phrase can simply be entered into a pop-up box.
Is this possible...or the"manual" process currently being used the only
option?
Thanks very much.
characters vary.
However, in all records, a certain exact phrase will always be present.
I'm needing to replace that phrase with another while keeping the rest of the
text the same.
Currently....I open the entire table...go to that field, and perform a
Find&Replace on that field using the "any part of field" match option. I
type the current phase into the Find What field and the new phrase into the
Replace With field.
This works fine and replaces all instances of that phrase.
I'd like to...if possible....use a parameter update query to do this so that
the replacement phrase can simply be entered into a pop-up box.
Is this possible...or the"manual" process currently being used the only
option?
Thanks very much.