Access to Word 2010 Form

[JohnWaltham]

Please:

I'm trying to pass data from Access 2010 (12 fields) to a Word form. The Access VBA code errors on my 12th field - an Access memo field - if the number of characters exceeds 256; if the field contains 256 characters or less, the data is successfully passed to the Word form.
The VBA errors on line
.FormFields("fldDeliverables").Result = Me!Deliverables

In the Access table the fieldtype is "memo", plaintext, and in the query and form the field is plaintext.

In the Word form, the Access memo field is linked to a legacy text form field whose Maximum Field Length is "Unlimited".

I think the problem is in Word rather than Access - but I've run out of ideas.

ANY suggestions would be greatly appreciated.

[Guessed]

Is there a reason you need the formfields in the Word document if you are using VBA to write it there anyway? Why not simply use a bookmark to serve as the location where the Access data needs to be inserted?

[gmaxey]

I believe the issue is the 255 character limit of the formfield.Result property. Why not use a content control?