Printing Information in Memo Field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have setup a form where infomation is stored in a number of fields, one of
which has a data type of Memo. I have setup a report to print the
information, however for the field that is a Memo it does not print all of
the information in the field in the table. In the properties box for the
report, I have set the 'Can Grow' field to Yes, but this does not help.
 
Only the first 255 characters will be displayed if:

a) you have anything in the Format property of the text box on the report,
or in the Format property of the memo field in the table, or

b) the report is based on a query that performs a comparison or
deduplication based on the memo field.

Some examples of b):
- Totals query (has GROUP BY clause), with GROUP BY on memo.
- DISTINCT predicate.
- UNION query.

For a Totals query, if the memo comes from a table where you are already
grouping on the primary key value, you can solve the problem by choosing
First instead of Group By in the Total row under the memo field. (This will
change the name to something like FirstOfMemo1, so you will need to change
the Name and Control Source of the text box on the report too.)
 
I am having this issue. I double checked the Format property in both the
Table and the Report and there is nothing in the Format property in either. I
then checked the query and it was not producing all the words and I changed
in totals, Group By to First. I rechecked the query and it shows all the
details. I thought my problem was solved, yet when I returned to the report
it still is only showing 255 characters, even though my query it is pulling
from shows all. Any suggestions?
 
Back
Top