Memo Field is truncating to 255 Chars

The source query is using "totals" and the condition for the memo field is
set to "First". This displays the entire contents of the memo field (more
than 255 chars), vs using "Group By" which truncates the field to 255 chars.

However, even though the entire string displays in the query - only the
first 255 print on a report. Is this normal?

Is there a way to print the entire string, other than a sub-report?

It seems you understand that to get Access to display the entire memo field,
you must avoid any aggregation on the field.

It sounds like you succeeded in doing that in your query, so (assuming this
query is the source for the report), it's time to look at the report. Open
it in design view. Open the Sorting And Grouping dialog (View menu.)
Anything in there that would cause Access to sort or group on the memo
field? Is the memo in the Detail section, or in some group header/footer? Is
there anything in the report's OrderBy property?

Another place to look is the Format property of the text box that shows the
memo. Clear anything from that property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jim Pockmire" wrote in message
...
The source query is using "totals" and the condition for the memo field is
set to "First". This displays the entire contents of the memo field (more
than 255 chars), vs using "Group By" which truncates the field to 255
chars.

However, even though the entire string displays in the query - only the
first 255 print on a report. Is this normal?

Is there a way to print the entire string, other than a sub-report?

The answer to your questions is generally "no". I even created a test report
using simple dummy data and a simple report which retrieves one record with
no grouping.

The report truncates the data wheras the query does not, so I am assuming
this is normal.

My work around is a sub-report, although the above would have been easier if
it worked.



"Allen Browne" wrote in message
...
It seems you understand that to get Access to display the entire memo
field, you must avoid any aggregation on the field.

It sounds like you succeeded in doing that in your query, so (assuming
this query is the source for the report), it's time to look at the report.
Open it in design view. Open the Sorting And Grouping dialog (View menu.)
Anything in there that would cause Access to sort or group on the memo
field? Is the memo in the Detail section, or in some group header/footer?
Is there anything in the report's OrderBy property?

Another place to look is the Format property of the text box that shows
the memo. Clear anything from that property.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jim Pockmire" wrote in message
...
The source query is using "totals" and the condition for the memo field
is set to "First". This displays the entire contents of the memo field
(more than 255 chars), vs using "Group By" which truncates the field to
255 chars.

However, even though the entire string displays in the query - only the
first 255 print on a report. Is this normal?

Is there a way to print the entire string, other than a sub-report?

Okay, so you have a subreport that works, but a main report that doesn't.
That may help you to identify what's the difference between the two.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jim Pockmire" wrote in message
...
The answer to your questions is generally "no". I even created a test
report using simple dummy data and a simple report which retrieves one
record with no grouping.

The report truncates the data wheras the query does not, so I am assuming
this is normal.

My work around is a sub-report, although the above would have been easier
if it worked.



"Allen Browne" wrote in message
...
It seems you understand that to get Access to display the entire memo
field, you must avoid any aggregation on the field.

It sounds like you succeeded in doing that in your query, so (assuming
this query is the source for the report), it's time to look at the
report. Open it in design view. Open the Sorting And Grouping dialog
(View menu.) Anything in there that would cause Access to sort or group
on the memo field? Is the memo in the Detail section, or in some group
header/footer? Is there anything in the report's OrderBy property?

Another place to look is the Format property of the text box that shows
the memo. Clear anything from that property.

"Jim Pockmire" wrote in message
...
The source query is using "totals" and the condition for the memo field
is set to "First". This displays the entire contents of the memo field
(more than 255 chars), vs using "Group By" which truncates the field to
255 chars.

However, even though the entire string displays in the query - only the
first 255 print on a report. Is this normal?

Is there a way to print the entire string, other than a sub-report?

Yes, the sub-report is based on single table with no grouping - so the memo
field does not become an issue


"Allen Browne" wrote in message
...
Okay, so you have a subreport that works, but a main report that doesn't.
That may help you to identify what's the difference between the two.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Jim Pockmire" wrote in message
...
The answer to your questions is generally "no". I even created a test
report using simple dummy data and a simple report which retrieves one
record with no grouping.

The report truncates the data wheras the query does not, so I am assuming
this is normal.

My work around is a sub-report, although the above would have been easier
if it worked.



"Allen Browne" wrote in message
...
It seems you understand that to get Access to display the entire memo
field, you must avoid any aggregation on the field.

It sounds like you succeeded in doing that in your query, so (assuming
this query is the source for the report), it's time to look at the
report. Open it in design view. Open the Sorting And Grouping dialog
(View menu.) Anything in there that would cause Access to sort or group
on the memo field? Is the memo in the Detail section, or in some group
header/footer? Is there anything in the report's OrderBy property?

Another place to look is the Format property of the text box that shows
the memo. Clear anything from that property.

"Jim Pockmire" wrote in message
...
The source query is using "totals" and the condition for the memo field
is set to "First". This displays the entire contents of the memo field
(more than 255 chars), vs using "Group By" which truncates the field to
255 chars.

However, even though the entire string displays in the query - only the
first 255 print on a report. Is this normal?

Is there a way to print the entire string, other than a sub-report?

Jim Pockmire wrote:
Yes, the sub-report is based on single table with no grouping - so
the memo field does not become an issue

Are you using the memo field in the report to do the grouping?

(you can't do that)

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Jim Pockmire wrote:

The answer to your questions is generally "no". I even created a test report
using simple dummy data and a simple report which retrieves one record with
no grouping.

The report truncates the data wheras the query does not, so I am assuming
this is normal.

My work around is a sub-report, although the above would have been easier if
it worked.


To add to Allen's list of things to check. Did you make
sure the memo's text box and its section bothe have their
CanGrow property set to Yes?

IMO, once the query is doing the right thing, this problem
is usually caused by some kind of grouping, aggregation or
sortingon the memo field.

--
Marsh
MVP [MS Access]