Exporting Access data into Word FormField Error

  • Thread starter Thread starter Robert S.
  • Start date Start date
R

Robert S.

Access doesn't seem to allow me to export a Memo data
field from Access into a Word FormField when the
corresponding memo type field in Access is over a certain
length.

I get a "4690String too long" error message. The
corresponding FormField in Word is designated as "Regular
Text" and set to Unlimited in size..

I am exporting the data from the Access memo field, into
the word formfield by using the following line:

..FormFields("DescriptionLead").Result = Nz(Me!
DescriptionOperations)

Thanks for any help.
 
On Thu, 14 Aug 2003 11:02:33 -0700, "Robert S."


is Me!DescriptionOperations from a SQL statement?

if yes then it is a string and no Memo anymore eg: varchar(254)

MW
 
I am exporting the data from the Access memo field, into
the word formfield by using the following line:
Click to expand...

Look up help for GetChunk and AppendChunk

HTH

Tim F
 
Hi Robert,
Access doesn't seem to allow me to export a Memo data
field from Access into a Word FormField when the
corresponding memo type field in Access is over a certain
length.
Click to expand...
The problem is a limitation on the Word-VBA end of things.
See this KB article:

WD97: "String Too Long" Using Over 255 Characters [Q163192]
http://support.microsoft.com?kbid=163192

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jan
24 2003)
http://www.mvps.org/word

This reply is posted in the Newsgroup; please post any
follow question or reply in the newsgroup and not by e-mail
:-)
 
Back
Top