 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Publisher / Programming / August 2005String data is truncated when imported from an Access db
I'm using VB code to import data from an Access 2002 database into a Publisher 2003 document. One of my data fields is a memo field. When I make the following variable assignment, the string from the memo field is truncated to 1529 characters. objVita = ActiveDocument.MailMerge.DataSource.DataFields.Item("MoreInfo").Value I don't know why, nor how to overcome this limit? > I'm using VB code to import data from an Access 2002 database into a > Publisher 2003 document. One of my data fields is a memo field. When > I make the following variable assignment, the string from the memo > field is truncated to 1529 characters. Congratulations, you have bypassed the traditional 255-character mail merge limit in Publisher. I have not done any merging with Publisher VBA, so I hadn't noticed that you could do this. I would hazard a guess that there is no way to avoid this truncation, just as there is no way through the UI to get more than 255 characters. If you use an OLEDB control or similar to access the database instead of the Publisher interface, you should get access to the whole field.  SignatureEd Bennett - MVP Microsoft Publisher > I would hazard a guess that there is no way to avoid this truncation, just > as there is no way through the UI to get more than 255 characters. If you > use an OLEDB control or similar to access the database instead of the > Publisher interface, you should get access to the whole field. Thank you, Ed. That not only solved the problem, it worked faster. Jason > Thank you, Ed. That not only solved the problem, it worked faster. Thanks for posting back, Jason - it's always appreciated :-) Glad to hear that I helped to fix your problem. SignatureEd Bennett - MVP Microsoft Publisher
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.