How do I insert Line Breaks in a field using Update Query or ?

[Translatory]

I am trying to insert Line Breaks in an Access memo Field using an Update Query, but I can never get it to work. For example, I have text that looks like this: "First Line¶Second Line¶Third Line." (actually a Table of Contents) in a Memo field and I want it to look like this after running the Update Query:

First Line
Second Line
Third Line.

I built my query as an Update Query and I inserted the following command in the “Update To:” field: Replace([Notes],"¶",Chr(13)+Chr(10))

I also tried using Replace([Notes],"¶",Chr(13) & Chr(10)). When I click on Run to run the query, the ¶ characters in my table Notes field are simply replaced with an empty space, not the Carriage return + Line Feed that I am looking for. I don’t know why it never works. I’ve worked more than 2 full days on this and tried every solution I could find online, but nothing works.

Would someone have any idea what’s stopping my Access 2010 from inserting line breaks in an Update Query? Or is there another better way to do this for hundreds of cells?

Thanks!

 

[JHB]

I don't know why you have such problem changing the character, therefor I send you a sample database, where I'm able to do it.
Open the only table and the query and run it.