Report text box question

[Vic]

Is there a limit on the number of characters a text box
can display on the detail section of a report? The
reason I as is because I have a textbox in a report and
the data is being truncated. The table does have the
entire data, but not all of it is being displayed on the
report. The textbox property Can Grow is set to Yes.

The table is an actual link to a SQL server database.
The datatype for the field in SQL server is nvarchar
(2000) and it shows it as "Memo" datatype in Access.
Please help.

 

[Rick Brandt]

Is there a limit on the number of characters a text box
can display on the detail section of a report? The
reason I as is because I have a textbox in a report and
the data is being truncated. The table does have the
entire data, but not all of it is being displayed on the
report. The textbox property Can Grow is set to Yes.

The table is an actual link to a SQL server database.
The datatype for the field in SQL server is nvarchar
(2000) and it shows it as "Memo" datatype in Access.
Please help.

If you've applied a format property to the field in the query or to the
control on the report the text will truncate at 255 characters. Likewise
if your query has a GroupBy on the field or is using DISTINCT.