![]() |
#1
|
|||
|
|||
![]()
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. |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
pboland | Word VBA | 1 | 06-12-2015 06:53 PM |
Form Merge Access 2002 to Word 2007 Issue | Lea-Andra | Word | 3 | 12-30-2014 07:09 AM |
![]() |
adunbar22 | Word | 3 | 09-11-2013 08:36 PM |
Updating Access with Word Form | b2995 | Word VBA | 0 | 10-16-2011 09:37 PM |
![]() |
WilfredoMolina | Office | 1 | 10-10-2010 06:47 AM |