Truncated memo field display

  • Thread starter Thread starter Marv
  • Start date Start date
M

Marv

Hi,

I have a very basic report displaying Last Name, First Name, Class, and a
Memo. Sorted by Class then Last name.

The report displays properly until I click on Sigma to set up the ability to
display the count of each Class. Without making any other change except
clicking on Sigma every memo field displayed in the report is truncated to
about 300 characters and spaces.

Thanks for any suggestions.

Marv
 
On Mon, 5 Oct 2009 09:58:34 -0400, "Marv" <[email protected]>
wrote:

I'm assuming you clicked on Sigma when designing the query for the
report.
It truncates at 255 chars, and that is by design. This is a
performance optimization, because grouping by a potentially very large
memo field can be too time consuming.

Fortunately, you don't need to Group By at all: leave the query the
way it was, and in your report create a grouping level for Class. Then
in that grouping level's footer create a textbox and set its
controlsource to:
=Count(Class)

-Tom.
Microsoft Access MVP
 
Back
Top