adding linefeed to memo field type

Question

The linefeed does not appear in access db:

Set db = OpenDatabase("C:\temp\a.mdb")
db.OpenRecordset("table1", dbOpenTable) 
.AddNew ' create a new record 
.Fields("memofield") = "123" + chr(13)+"line2"
.Update ' stores the new record

Answer 1

I'm not entirely sure, ,but I believe you need to use a combination of chr 13 & 10:

.Fields("memofield") = "123" + chr(13) + chr(10) + "line2"