search and delete text

I have a memo field that contains the same phrase in every record.

Is there any way other than editing each record to get rid of the phase.

gls858

You can run an update query (make a copy of the database file first!):

UPDATE YourTableName
SET MemoFieldName = Replace(MemoFieldName, "That Pesky Phrase", "")
WHERE MemoFieldName Like "*That Pesky Phrase*";

--

Ken Snell
MS ACCESS MVP
http://www.accessmvp.com/KDSnell/


"gls858" wrote in message
...
I have a memo field that contains the same phrase in every record.

Is there any way other than editing each record to get rid of the phase.

gls858

Ken Snell [MVP] wrote:
You can run an update query (make a copy of the database file first!):

UPDATE YourTableName
SET MemoFieldName = Replace(MemoFieldName, "That Pesky Phrase", "")
WHERE MemoFieldName Like "*That Pesky Phrase*";


Thanks Ken that did the trick. I appreciate the help.

gls858