Exporting Memo field in Access 2000 (quick HELP needed)

  • Thread starter Thread starter KT
  • Start date Start date
K

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.
 
KT said:
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.
Click to expand...

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;
 
Back
Top