I have an issue with mail merging using Access database that I have never encountered before.

In one table, I have a text field that contains a number of selections from another table (theatrical characters form a "Character" Table selected from a drop down menu in a form and inserted into "Characters" field in scene details table to be precise).

When I insert that field into a merge document (either Word or Publisher), it returns just the first two letters of the field content.

I am sure that this is an issue with the database because I have tried a merge in Word and in Publisher with the same results. The fields show truncated in the "Select Recipients" tool but, in the database they show up fully in tables and queries.

I've tried creating a query from the table and using that as the source with the same effect. The table and query shows the full contents.

This database was originally designed in Office 2007 and I had no issues with it then.

Your help would be so appreciated.



Thanks