Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 06-06-2016, 10:45 PM
JohnWaltham JohnWaltham is offline Windows 10 Office 2010 32bit
Novice
Access to Word 2010 Form
 
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
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Access to Word 2010 Form 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
Access to Word 2010 Form 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
Access to Word 2010 Form Microsoft Access 2010 Error open a Web Form WilfredoMolina Office 1 10-10-2010 06:47 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 09:24 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft