replace in code

[Pawe³ Pa³asz]

Hi all
I didn't find it anywhere: how can i replace strings in the table rows from
the VB Code?
Regards

 

[R. Hicks]

Maybe this will simplify the syntax ...

Replace("StringToSearch", "StringToFind", "StringToChangeTo")

RD

 

[Howard Brody]

I usually build an UpdateQuery in design view, copy the
SQL into VB (just to make sure I have the syntax correct)
and then run the code using the RunSQL command.

Hope this helps!

Howard Brody

 

[Pawe³ Pa³asz]

Well, what i want to do is the same when you mark a column, choose replace
from menu, do replace. I want to do the same from VB Code.