>I tried to put a CR in a memo field with CHR() but it does not seem to work.
>How do I get my memo field ready for a new line of text?

The new line combination is CR+LF -> CHR(13)+CHR(10).

lcCrLf = CHR(13)+CHR(10) 
lcMemo = "Line 1" + lcCrLf + "Line 2" + lcCrLf + "Line 3"
REPLACE mymemo WITH lcMemo