Exporting Memo field in Access 2000 (quick HELP needed)

[KT]

I have a memo field that contains carriage return line feeds (CRLF)
throughout the memo field. When i export it, the field is being cutoff.

Does anyone have a way to remove the CRLF?

Thanks in advance.

 

[Dirk Goldgar]

I have a memo field that contains carriage return line feeds (CRLF)
throughout the memo field. When i export it, the field is being
cutoff.

Does anyone have a way to remove the CRLF?

Thanks in advance.

Instead of exporting the table directly, export a query that uses the
Replace function to substitute some other character for the CRLF
combination. For example,

SELECT
IDField,
Replace([MemoField], Chr(13) & Chr(10), "|", 1, -1, 0)
As MemoText
FROM
TableWithMemoField;