Summary
The double quote character cannot be used directly as parameter in Replace() function...The ANSI encoding must be used.
Question
The double quote characters cannot be used directly as second parameters in replace() function because it must be between two double quotes.
Answer
To replace the double quote character in a string with the Replace() function, the use of ANSI encoding is mandatory.
So to replace the double quote in [Field1] by nothing, the script will be:
Replace([Field1], chr(34), "")
So to replace the double quote in [Field1] by nothing, the script will be:
Replace([Field1], chr(34), "")