Exporting a memo field

[ThePolymathicMonk]

I have gone through the previous posts and answers and I am still having
problems...I have a large memo field in an Employee management DB which
contains the narrative portion of an individual's resume. I would like to be
able to send it to a text file so it can be send to the individual for
periodic updating (we are a small Defense research company in the DC area,
with employee's all over the country). I have tried the "TransferText"
Method and the field STILL gets truncated...is there any way around this?

 

[John Nurick]

Are you applying any kind of a format to the field (e.g. something in
its Format or InputMask property in the table definition)? That causes
truncation.

Also, if you're using a query for the export and the query uses a
calculated field for the memo field contents (e.g. if you're adding a
header line or a disclaimer, or modifying them with a Replace()
expression), the result will be treated as a Text field instead of a
memo, and truncated.

If you're exporting the memo field unaltered, and there's no Format or
InputMask involved, it should go through OK. If you need to use a
calculated field, you can either
1 Append the records to be exported to a temporary table
(the memo field won't be truncated).
2 Export the records from the temporary table.
or write VBA code to generate the text file for you.