Fixing Report page problems

[ljungers]

Hope someone can help me. I have two problems with a report that is using a memo text field in the body of this report. THis body could produce a half page to 4 or 5 pages of text.

When I run the repot I get only 1 page even when selecting a table row that contains more than 1 page of text to print.

2nd problem is that the spacing control characters are placed in this memo field (Carriage Return, Line Feed). The printed report has a L (not the letter L) printing where erver there are CR and 2 LF's. How can I set the report to not print this special character.

Thanks for any help on this.

[NeoPa]

1. You can't have any field within a report throw a page. It would make nonsense of the page handlig facilities in Access.
2. You could try using the Replace() function, but I would think that even the VbCrLf sequence would not work within a field. Again, that's what the report formatting is supposed to do. If you had lines thrown within a control it would take control away from the formatting of the report.