By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,852 Members | 2,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,852 IT Pros & Developers. It's quick & easy.

Fixing Report page problems

P: 114
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.
Mar 10 '07 #1
Share this Question
Share on Google+
1 Reply

Expert Mod 15k+
P: 31,470
  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.
Mar 11 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.