Hello ConfusedAccessUser,

How do you figure that Excel is truncating the data. If it is because you
cannot see the enitire data in a cell then that is only because cells can
contain larger amount of data than they can display. I think they can display
upto 512 characters but can contain more.

Alok Joshi

"Confused access user" wrote:

When I port my data from access to excel the data truncates. In access the I
use a text box with the can grow setting. I have verifed that the data is
stored in the excess table. When I port it to excel using the report
feature, my data is truncated.