Help please. Is Very Urgent.

[Thomas]

I have a DB in Access with many tables & queries and a Word document merging
fields from one of the queries. All the merged fields are working right , but
one of
them.

The problematic field have a very large text (over 3500 characters) but the
merged
field only shows 255 of them. Why?

How to expand the amount of characters shown in a merged field In Word?

The SQL Statement is:
SELECT ArtWork.Condition, ArtWork.PaintNo, Condition.Code1, Condition.Code2,
Condition.Code3, Condition.Code4, Condition.Code5, Condition.Code6,
Condition.Code7, [Code1] & [PaintNo] & [Code2] & [PaintNo] & [Code3] &
[PaintNo] & [Code4] & [PaintNo] & [Code5] & [PaintNo] & [Code6] & [PaintNo] &
[Code7] AS Code
FROM Condition INNER JOIN ArtWork ON Condition.Condition = ArtWork.Condition;


I tryed also with this one, but unsuccessfully:
SELECT Condition.Condition, ArtWork.PaintNo, [Condition]![Code1] &
[ArtWork]![PaintNo] & [Condition]![Code2] & [ArtWork]![PaintNo] &
[Condition]![Code3] & [ArtWork]![PaintNo] & [Condition]![Code4] &
[ArtWork]![PaintNo] & [Condition]![Code5] & [ArtWork]![PaintNo] &
[Condition]![Code6] & [ArtWork]![PaintNo] & [Condition]![Code7] &
[ArtWork]![PaintNo] AS Code
FROM Condition INNER JOIN ArtWork ON Condition.Condition = ArtWork.Condition;


My Access & Word are 2003, but the access file is formated as 2000.
I would appreciate any help. Thanks.

 

[Dave Jones]

The problem is more likely to be with the doc than your query.
As far as I remember, a form field is limited to 255 chars.
You need to use a bookmark for fields with a length greater than this.

Dave