Memo Length Restriction

[Guest]

I have some users who are budding authors generating large memo fields.
Because I have to run the report in landscape it reduces my page length for
the expanding field. When the text box width is big enough for the entire
memo to fit on one page it works, otherwise it hangs. I don't want to
restrict the memo field, just cut off the output in the report. So, is there
a way to limit the text box length of a growing memo field only in the
report? Thanks.

 

[John Vinson]

I have some users who are budding authors generating large memo fields.
Because I have to run the report in landscape it reduces my page length for
the expanding field. When the text box width is big enough for the entire
memo to fit on one page it works, otherwise it hangs. I don't want to
restrict the memo field, just cut off the output in the report. So, is there
a way to limit the text box length of a growing memo field only in the
report? Thanks.

You could base the Report on a Query with a calculated field:

ShowMemo: IIF(Len([memofield]) > 2500, Left([memomemofield], 2500) &
"... <see database>", [memofield])

to cut their verbosity out of the report without affecting the actual
stored data. Of course, adjust 2500 to your preference.

John W. Vinson[MVP]

 

[Arvin Meyer [MVP]]

Sure. Use a query as the recordsource for the report. Add a column for use
in the report:

ReportMemo: Left([MemoField], 500)

will give you the first 500 characters. Adjust to suit.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

 

[Guest]

Thanks to both Arvin and John. I guess I was so focused on modifying the
report that I forgot I could modify the query feeding the report. Your
solutions worked great and the report is on its way.

Sure. Use a query as the recordsource for the report. Add a column for use
in the report:

ReportMemo: Left([MemoField], 500)

will give you the first 500 characters. Adjust to suit.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access

I have some users who are budding authors generating large memo fields.
Because I have to run the report in landscape it reduces my page length for
the expanding field. When the text box width is big enough for the entire
memo to fit on one page it works, otherwise it hangs. I don't want to
restrict the memo field, just cut off the output in the report. So, is there
a way to limit the text box length of a growing memo field only in the
report? Thanks.