Access to Word 2010 Form
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.
|