#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
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?
__________________
Andrew Lockton Chrysalis Design, Melbourne Australia |
#3
|
|||
|
|||
I believe the issue is the 255 character limit of the formfield.Result property. Why not use a content control?
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Export Word Form Data to Access | 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 |
Word 2010 Dynamic Form | adunbar22 | Word | 3 | 09-11-2013 08:36 PM |
Updating Access with Word Form | b2995 | Word VBA | 0 | 10-16-2011 09:37 PM |
Microsoft Access 2010 Error open a Web Form | WilfredoMolina | Office | 1 | 10-10-2010 06:47 AM |