If you use this formula, and export the table data to fixed-width text, you get the result you were looking for. Using v9 Pro, exporting the table to XLS or CSV doesn't preserve the line break.
You could try putting in codes like "
" into the memo field, instead of the CHR values, and then having a macro in Access that replacing these codes automatically with CHR 13, CHR 10.
You're absolutely on the right track with your approach, and it should have worked as you intended.
Unfortunately, as you discovered, it didn't, and - for now at least - it won't (see my first reply, #2, in [URL="http://www.monarchforums.com/showthread.php?t=3143"]this thread[/URL]).
Olly has supplied a great option. Just be sure to add some very unique string to your data so that Access can handle the carriage return and new line that you'd intended Monarch to handle. Something like "QWQWQWQ" or some such string that won't ever appear in any normal data.
Excel has a VBA constant that Access ought to have as well, but I haven't verified it: vbCrLF.