Why is the text in my memo boxes being truncated in my reports?

[Guest]

I'm working on a database for work that involves creating multiple unique
reports for deep-sea submersible dives. A portion of the report includes
three memo boxes that contain information on the biological and physical
environment of the area encountered by the sub. I was under the impression
that memo boxes could contain up to 64,000 characters, yet when I run my
reports the text inside the boxes is truncated to 255 characters. Any
suggestions?

 

[John Spencer]

If your query uses DISTINCT or it is a TOTALS query or a UNION query your
memo fields will be truncated.

If you apply any formatting to the memo-field controls, the data will be
truncated.

 

[Guest]

Thanks John! I feel pretty dumb that I spent time racking my brain over this
issue when it was a simple as changing the type of query. But oh well, we
can't all be rocket scientist all of the time!
Thanks again.

 

[Guest]

Hi John,

I have the same problem.
What's a DISTINCT, TOTALS or UNION query?
How do I know whether the query I selected is any of the above and how do i
make sure it is none of these?

Thanks so much.

 

[John Spencer]

If you can open your query in the query grid, it is not a UNION query. That
can only be created in the SQL text view.

The easiest way to identify the query is to change the view to SQL and look
for the following:

UNION or UNION ALL between two (or more) query statements

"SELECT Distinct " at the beginning of the query.

SUM, GROUP BY, COUNT, Average or other aggregate functions within the Query.

In the query grid - if you have a Totals Line in the grid then you have a
"Totals" query or an aggregate query.
In the query grid properties for the query, if Unique Values = "Yes" then
you have a Distinct query.