I have some "memo" datatype fields in my form which were used for the clients penchant for heavy verbage. This has caused a problem when outputing the text from those fields to reports.

We can't get "carraige returns" to work within the reports.

Has anyone ever encountered this and how was the issue dealt with?

Thanks, bph

Are the carriage returns within the memo itself or between memo field and some other fields (memo or otherwise)

If the latter, encode using Chr((13) & Chr(10))
exactly as typed...this will produce a carriage return
J

There aren't any in put within the fields at all. The client would like a carriage return to occur on the report to make the text fit a standard 8x11 piece of paper.

Set the report textbox Format CanGrow property to True

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]