How to convert one string to another

[galsaba]

On my table I have a memo type field "notes".
I want to convert the text. Whenever the word "John" mentioned, i want
it to be converted to "Bill".
For example.
If in one record "notes" says: "John went to school, and then John came
back" , it will be converted to "Bill went to school, and then Bill
came back.

Any idea how to do this?

Thanks,

galsaba

[Gaspare]

"galsaba" <ga*****@aol.com> ha scritto nel messaggio
news:11**********************@g14g2000cwa.googlegr oups.com...

On my table I have a memo type field "notes".
I want to convert the text. Whenever the word "John" mentioned, i want
it to be converted to "Bill".
For example.
If in one record "notes" says: "John went to school, and then John came
back" , it will be converted to "Bill went to school, and then Bill
came back.

Any idea how to do this?

Thanks,

galsaba

Hello,
use the function Replace ( documentation by help...) how in this example

Replace (notes, "John","Bill")

ok?

Good Night

[galsaba]

Great!
Thanks!!

[galsaba]

Great!
Thanks!!

[galsaba]

I just found out this this function exists in access xp but not in
access 2000. Any solution?

[Terry Kreft]

It exisits in Access2000 but can't be used in queries.

Wrapping it in your own function should work e.g.

Public Function MyReplace( _
Expression As String, _
Find As String, _
Replace As String, _
Optional Start As Long = 1, _
Optional Count As Long = -1, _
Optional Compare As VbCompareMethod = vbBinaryCompare) As String

MyReplace = VBA.Replace(Expression, Find, Replace, Start, Count, Compare)

End Function

Which in your example becomes
MyReplace([notes], "John", "Bill")

"galsaba" <ga*****@aol.com> wrote in message
news:11**********************@l41g2000cwc.googlegr oups.com...

I just found out this this function exists in access xp but not in
access 2000. Any solution?