Find and Replace Specific Strings

[HenryAnthony]

Hi and Happy Holidays to All!

In a certain field in a table, I need to search for certain characters such as spaces and punctuation and replace them either with nothing or with other special characters.

I then need to search all fields for "'" and replace with "\q".

Currently, I do this manually but am looking for some code that would eliminate this step.

Any help would bring you my adulation and stars!

Best regards,

Henr¥

 

[p27br]

Use the seek method of the recordset object.

 

[MisterC]

You can use the Replace function.
REPLACE
Replaces part of a text string with a different text string.

Syntax

REPLACE(old_text,start_num,num_chars,new_text)

Old_text is text in which you want to replace some characters.

Start_num is the position of the character in Old_text that you want to replace with New_text.

Num_chars is the number of characters in Old_text that you want to replace.

New_text is the text that will replace characters in Old_text.
--------------
A little knowledge is a dangerous thing.