Limited data for memo -field in Repports

[Downy]

In my report is a memo field that sometimes contains a half page text. When
I view the report on my monitor a slider is shown. That's oke. When I print
the Report I want all the info on the page. This is not possible. The report
gives only a part of it (30 character 4 lines or something) In the
properties I set for the option that the field automaticaly can change
depending on the amount of data! I could not find a solution on the site of
Microsoft (Knowledgebase). I use the latest update (Office 2000 sp 3 -
Access 2000 with XP-prof.

Is there a workaround for this problem?

Thanks
Marcel

 

[Rick Brandt]

In my report is a memo field that sometimes contains a half page
text. When I view the report on my monitor a slider is shown. That's
oke. When I print the Report I want all the info on the page. This is
not possible. The report gives only a part of it (30 character 4
lines or something) In the properties I set for the option that the
field automaticaly can change depending on the amount of data! I
could not find a solution on the site of Microsoft (Knowledgebase). I
use the latest update (Office 2000 sp 3 - Access 2000 with XP-prof.

Is there a workaround for this problem?

Either your query or your report is truncating the memo text at 255 characters.
There are several things that will do this.

Look directly at the datasheet of the query and see of all the text is there.
If not then look at the "Unique Values" property. That has to be set to No.
Does the query have "View Totals" turned on? If so then you must not use Group
By on the Memo field. Also you should have no format property applied to the
memo field.

If the query is not truncating the data then look at the report. You cannot use
the memo field to create a group section in your report. You cannot have a
format property applied to the TextBox used to display the memo field. There
might be others, but that's all I can think of at the moment.

 

[Basr]

Either your query or your report is truncating the memo text at 255 characters.
There are several things that will do this.

Look directly at the datasheet of the query and see of all the text is there.
If not then look at the "Unique Values" property. That has to be set to No.
Does the query have "View Totals" turned on? If so then you must not use Group
By on the Memo field. Also you should have no format property applied to the
memo field.

If the query is not truncating the data then look at the report. You cannot use
the memo field to create a group section in your report. You cannot have a
format property applied to the TextBox used to display the memo field. There
might be others, but that's all I can think of at the moment.

---

Thank you Rick
I removed tGroup By from the query and the problem was solved.
Thanks

Marcel