Export Memo to txt - truncates at 255

[JamesSF]

This has got to be easy- but i cannot figure it out

i am trying to export to a txt file data over 255 chars - it keeps
truncating it

I have tried putting the data to a temp table with a memo field, as
suggested in
http://support.microsoft.com/default.aspx?scid=kb;en-us;207668

still truncates when using:

DoCmd.TransferText acExportFixed, "schema", "table", "c:\filename.txt",
False, ""

BUT not when manaually exporting - i can rightclick the table, export, fix -
works.

i need this to work from code automatically - any suggestions?

thanks in advance

JamesSF

 

[John Nurick]

How many characters did you allow for the memo field in your export
specification? Are there any line breaks in the data in the memo field?