Memo field data getting cut off (using Output To action in macro)

[Brad Thuston]

Using Access 2003 (on an Access 2000 format db). Am attempting to use the
OutputTo action (via macro) to save reports to Rich Text Format (.rtf). I
need to be able to send the saved .rtf file so that the recipient can edit
and send back.

Problem:
Memo fields from the report are getting cut off; and I also end up with
additional blank pages (inadvertently) between some of the detail records.

Funny thing is... it does not cut them off in every case. Any assistance is
greatly appreciated.

Thanks - Brad

 

[Allen Browne]

Several possible issues, e.g.:

1. Formatting.
If there is anything in the Format property of the memo field in your table,
or the Format property of the text box on your report, the text will
truncate at 255 characters.

2. Aggregation
If the report is based on a query that performs any aggregation on the memo
field, it will truncate at 255 characters. This includes a GROUP BY clause,
or a DISTINCT predicate. If the Group By is the problem, try choosing First
in the Total row in the query under the memo field.

3. Bug
See:
Memo Field That Is Exported to RTF Format May Be Truncated
at:
http://support.microsoft.com/?id=288877
Although the article related to Access 97, there are reports of later
versions doing this also.

 

[Brad Thuston]

Thanks for the feedback... I'll check those options and let you know if it
solved the problem. Thanks, again.