Memo Fields on Reports

[Mike Morton]

this must be one of the dumbest questions. I am printing
a memo field on a report, the print out is limiting the
field to some number of characters (maybe 50, maybe more,
I have not counted). There is no limit in the format box
in the properties dialog box. The field type in the table
is memo and the field contains all data, no limit on the
form. What needs to be set to allow full printing of the
data?

 

[fredg]

this must be one of the dumbest questions. I am printing
a memo field on a report, the print out is limiting the
field to some number of characters (maybe 50, maybe more,
I have not counted). There is no limit in the format box
in the properties dialog box. The field type in the table
is memo and the field contains all data, no limit on the
form. What needs to be set to allow full printing of the
data?

Check the report's record source (if it is a query).

From Marshall Barton's reply to another poster a few days ago:
** snipped**
If the query does anything that requires the
memo field to be compared, it will be truncated to 255
characters. The query operations that perform a compare
operation are DISTINCT, GROUP BY, ORDER BY, UNION, etc. If
your query uses one of those keywords, try to find a way to
avoid it, use an alternative the memo field (use First
instead of Group By, Left in the Order By, UNION ALL, ???)
If that doesn't get you goping, post the query so we can see
its exact syntax.

Setting a memo field's Format property will also truncate
the returned results.

 

[Marshall Barton]

this must be one of the dumbest questions. I am printing
a memo field on a report, the print out is limiting the
field to some number of characters (maybe 50, maybe more,
I have not counted). There is no limit in the format box
in the properties dialog box. The field type in the table
is memo and the field contains all data, no limit on the
form. What needs to be set to allow full printing of the
data?

Have you set both the text box control and its section's
CanGrow property to Yes?

 

[Guest]

----- fredg wrote: ----

On Wed, 19 May 2004 14:30:45 -0700, Mike Morton wrote

this must be one of the dumbest questions. I am printing
a memo field on a report, the print out is limiting the
field to some number of characters (maybe 50, maybe more,
I have not counted). There is no limit in the format box
in the properties dialog box. The field type in the table
is memo and the field contains all data, no limit on the
form. What needs to be set to allow full printing of the
data

Check the report's record source (if it is a query)

From Marshall Barton's reply to another poster a few days ago
** snipped*
If the query does anything that requires th
memo field to be compared, it will be truncated to 25
characters. The query operations that perform a compar
operation are DISTINCT, GROUP BY, ORDER BY, UNION, etc. I
your query uses one of those keywords, try to find a way t
avoid it, use an alternative the memo field (use Firs
instead of Group By, Left in the Order By, UNION ALL, ???
If that doesn't get you goping, post the query so we can se
its exact syntax

Setting a memo field's Format property will also truncat
the returned results.
--
Fre
Please only reply to this newsgroup
I do not reply to personal email

Thanks for the help. Got it solved.

 

[Guest]

----- Marshall Barton wrote: ----

Mike Morton wrote

this must be one of the dumbest questions. I am printing
a memo field on a report, the print out is limiting the
field to some number of characters (maybe 50, maybe more,
I have not counted). There is no limit in the format box
in the properties dialog box. The field type in the table
is memo and the field contains all data, no limit on the
form. What needs to be set to allow full printing of the
data

Have you set both the text box control and its section'
CanGrow property to Yes