Replace a specific character in the memo field

[Bonnie]

I need to replace a specific character in a memo field
with its unicode string, say &#37032. If I use "find and
replace", Access replaces all characters in the field with
the unicode string, i.e. the value of the field becomes
&#37032&#37032&#37032&#37032 . There are more than 6
thousand records in this database. What is the best way to
handle this?

 

[John Vinson]

I need to replace a specific character in a memo field
with its unicode string, say &#37032. If I use "find and
replace", Access replaces all characters in the field with
the unicode string, i.e. the value of the field becomes
&#37032&#37032&#37032&#37032 . There are more than 6
thousand records in this database. What is the best way to
handle this?

Depends on your version of Access. If you have 2002 or later, you can
use an Update query to update Memofield to

Replace([Memofield], "X", &#37032)

to replace all the X's with the selected character.

If you have an earlier version post back - it can still be done but
requires an extra step or two.

John W. Vinson[MVP]
(no longer chatting for now)