Text being clipped in reports

[STiruchi]

One of my text fields in the report (control source 'memo' field) gets
clipped. I tied using 'Can grow=Yes' but that didn't help either. Can
this be rectified?

Thanks in advance for any help.

ST

 

[Golfinray]

First off, use canshrink=yes. Then go to file/page setup/page and check your
page size. That is probably where you will find the problem.

 

[John Spencer]

Clipped how?
Truncated to 255 characters if it is over that or just the last line is
sometimes missing or ???


John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County

 

[STiruchi]

Yes, truncated to 255 characters.

 

[John Spencer]

Several things can cause this.

If you apply a format to the control that is bound to the memo field,
the field will be truncated. If you sort by the memo field that can
truncate the memo field.

The next place to check is the query. Did you use a distinct clause or
did you use a totals query?

Post the SQL of the query that you are using for the report. If that
query is using other queries, you may need to post them also.

TO post the SQL, open the query in design view and then select VIEW: SQL
from the menu.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================