Long report

[garyd1234]

Hi,
I have about a 7 page typewritten document consisting of contract wording that needs to be included with an itemized report in access. The report is a wordperfect doc. I tried various methods or cutting/pasting, linking etc into a report and it cuts off my report after the second page. Is there a limit to how long a report can be? How do I get it to all go into a report? Do I put it in a label or text box or link it? Help! Thanks

 

[Joe4]

Just a thought...

Could you convert your WordPerfect to a Word document, and then do a Mail Merge from Access? I do that for a lot of reports I do, as Word has better formatting features than Access.

BTW, I checked, and it looks like Access limits my reports to two pages. I don't know if there is a way to override this. The only other I can think of in Access is to split it into multiple reports.

 

[garyd1234]

putting sub reports on the report form works and continuing the body of the report into the next sub report works. The only problem is when it prints the report it will page break where ever it wants including cutting the tops off your letters. Any way you know to tell it to break between two typewritten lines and not cut the bottoms off the letters and put them on the next page?

 

[Joe4]

You can place insert "hard" page breaks, if that helps any. Also, within each section, you set the "Keep Together" property to "Yes".