Inserting HTML Code

[warrenk]

I have a memo field (rich text). I am trying to enter html code <br> in a replace command:



ie. Replace([File1]![Field1],'<br><br>','<br>')

What ends up happening is I am getting the line breaks...but the actual code is not inserted into my field. Any advice?

Thanks for any help!

[Dal Jeanis]

1) Is the following correct?
Before you run the replace, you can see <br><br>, and after the replace, you see invisible carriage returns/linefeeds in field1?
2) How precisely are you executing the replace? Is it part of an SQL query, VBA, or what?
3) What is the exact code that does that?