ADP report truncates field at 4000 characters

[Guest]

Access 2000 (SP3) ADP report fronting SQL Server 2000 (SP3). Report uses a
View as record source. Among the fields in the view is one defined as
varchar(8000). Report works fine except it truncates the data in this one
field at 4000 characters. Field is set to Can Grow. It continues to next
page all right. Double-checked view in Query Analyzer--no problems there.

What's odd is that it appears the data is returned to the report OK. When I
check the length of the data in the questionable field during the
Detail_Print event, it gives me the expected value. However, the report
displays only the first 4000 characters.

Tried using a stored proc as record source--same result. Tried a report
with ONLY the field in question on it--same result. An unbound form in same
app populated via an ADO recordset built via stored proc displays all data
correctly.

Any help is greatly appreciated.
X.

 

[Guest]

As the data comes into the report, I tried Debug.Print as well as writing the
text beyond the 4000 character mark to a textfile. It's just a bunch of
garbage.

Then I changed the datatype for the field in question from varchar(8000) to
text. This worked. It's a viable workaround, though I'd still be interested
in anyone else's ideas.

Thanks.
X.