String data is truncated when imported from an Access db

[Jason]

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?

 

[Ed Bennett]

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.

 

[Jason]

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

 

[Ed Bennett]

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.