Thread: [Solved] Access to Word 2010 Form
View Single Post
 
Old 06-06-2016, 10:45 PM
JohnWaltham JohnWaltham is offline Windows 10 Office 2010 32bit
Novice
 
Join Date: Jun 2016
Posts: 1
JohnWaltham is on a distinguished road
Default 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.
Reply With Quote