ADP report truncates field at 4000 characters

[Guest]

Pardon the cross-post--I must have overlooked this NG when originally posting
to microsoft.public.access.reports. The below includes my original post as
well as some new findings. Original problem still exists.
X.
***************************
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.

 

[Robert Morley]

I don't know anything specific, but it sounds like some kind of bug where
the ADP is trying to interpret your varchar(8000) as an nvarchar(4000).

Since you've said that the text datatype works, if you want to keep your
varchar(8000), how about building an SP that uses the text datatype
externally, but converts it to a varchar(8000) internally?


Just a thought,
Rob

 

[Guest]

Yep--I ended up with a similar solution--converting the varchar(8000) to text
datatype in the views that act as report recordsources. This works just fine.

We're about to move to Access 2003. I'll be curious to see if I can
recreate the problem. I'll look into submitting it officially as an issue if
I can.

Thanks for your time.
X.

 

[Guest]

I confirmed, at least on our test machines here, that this is NOT an issue
with Access 2003.
X.