Re: Exporting a memo field

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.

On Fri, 12 Aug 2005 21:09:02 -0700, "ThePolymathicMonk"
<ThePolymathicMonk@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

>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 [Microsoft Access MVP]

Please respond in the newgroup and not by email.
.