How can I replace two characters simultaneously in MS Access?

Question

By using Replace function, it's possible to replcae one character. Is there any way by which I can replace two chrs simultaneously..?

I mean two different characters for example
"I am learnin" is string and I want to replace all "n" and "e" with "R"

Answer 1

Use the same function:

Sub test()
Dim str As String, ans As String

str = "no great is no great is no great"

ans = Replace(str, "no", "the")

MsgBox ans
End Sub

Answer 2

get admission to can't try this. you will would desire to enter the information your self till you write some code which will finished this for you. you ought to do a Append question to append all the the help of one table to a various. yet for what your prepared to try this sounds greater like some code writting to get it to do purely what you prefer it too.

Answer 3

Same function - read the documentation again!

Rawlyn.