memo field truncated

[Guest]

I took over a program developed in Access2000. During the export the memo
fields are truncated. I am new to Access programming and the developer is no
longer with the company. How can I stop the truncating. Here is the code
that does the export:

DoCmd.TransferDatabase acExport, "dBase III", "c:\tms\upload", acQuery,
"qryExp_ITO_All", ("cito.dbf"), False

Thanks

 

[Jeff Boyce]

Rex

I did a quick Google search on
MS Access memo field truncated
and came up with a number of leads.

This one may prove most useful...
http://allenbrowne.com/ser-63.html

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

 

[Guest]

Thanks Jeff.

That gives me some more things to try. I had already did a number of yahoo
searches but none pointed me to this document.

Rex