Replace Function with "," in string in access 2007 <p>Suppose I have:</p> <pre><code>Str1 = "Corpse" Str2 = "Co, p" </code></pre> <p>Now I want to use "Replace Function" and color "Co" and "p" in "Corpse". Can I do this?</p> <pre><code>x = Str1 y = Str2(?) z = "&lt;font color=#ee00ee&gt;" + y + "&lt;/font&gt;" Replace(x, y, z) </code></pre>