Memo Field in Report (based on Query)

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

Hi all !

I wonder if anyone could help. I need to create a Report based on a query
that pulls data from numerous tables in my database, one of the fields I
require in the report happens to be a Memo field. The problem I have is
that when pulling data in a Memo field from a Query I only get the first 255
characters in the result, the rest is not retrieved. Is there any way I can
get round this, I need all the text in the memo field to appear in the
report but the data the report must produce needs to come from a variety of
tables.

Any help would be hugely appreciated ! Kind Regards

Dan
 
Dan said:
I wonder if anyone could help. I need to create a Report based on a query
that pulls data from numerous tables in my database, one of the fields I
require in the report happens to be a Memo field. The problem I have is
that when pulling data in a Memo field from a Query I only get the first 255
characters in the result, the rest is not retrieved. Is there any way I can
get round this, I need all the text in the memo field to appear in the
report but the data the report must produce needs to come from a variety of
tables.
Click to expand...

Memo field truncation can be caused by several different
things in the query. The most common are using the memo
field in a Group By or Order By clause. Using DISTINCT or
UNION are other causes. Run your query by itself to see if
the memo field is truncated by the query.

If the entire field is returned by the query, then make sure
that the text box that displays the memo field does not have
anything in its Format property.
 
Hi !

This worked perfectly, my Query had a 'GROUP BY' clause included in the
statement. I removed this and the query now pulls the full field into the
report. Many thanks for your speedy reply, I'm most grateful !

Regards

Dan
 
Back
Top