Print Two Pages on one sheet of Paper

[talktime]

Hi
i have a Access 2003 report that has many pages. each page has one record on it and a little Static text that only needs half of the sheet to, remaining half of the sheet wastes. Can i print two pages on one sheet, One Up and one down (or side by side) on the same sheet.

Thanks in anticipation

[June7]

What is forcing the page break between records?

I don't know any way to print two report pages on one sheet.

[talktime]

Here is my report design


[Report Header] Blank
[Page Header]

[Student ID Header]

[Detail]

[Student ID Footer] This section is set to "Force New Page" 'after section' in Properties sheet

[Page Footer]Blank
[Report Footer]Blank

Thanks for consideration

[June7]

If each output had the same space requirement, everything could be put in the Detail section and set size of the section so that only 2 records fit per page. Unfortunately the listing of unpaid months makes this impractical. A subreport of the unpaid months might make this idea doable. Depends how many months could be listed. Could the list be long enough for multiple pages?

The address is fixed to Mr. Father's Name? What if there is no father?

Father's Name is a field in table? Advise not to use special characters and punctuation (underscore is exception) in field names.

[John_G]

Hi -

You might be able to do this by defining a report that prints to "labels", and then define the "labels" to be 2 per page.

John

[June7]

Printing to labels not something I have ever done - interesting idea. How is this defined?

I have a report that prints records in multi-column setup. This gives the effect of 24 labels (or cards) per page. However, all the data is in the Detail section and the space used for each record is fixed.

[talktime]

@ June 7: as you said the list of unpaid months make it impractical to fix the output space for print. list of unpaid months including student id footer can only spans on one full page.
is there a way, if it takes more than half of the page, next record should print on next page, if it not it should print on the same page? or is it possible Student footer ID not cannot fit to print on the same page the whole record with header and footer should print on next page.

[June7]

That is not within my experience. I can't even imagine how it could be done, if at all. Report/Detail/Group sections Headers/Footers (exception is page section) have a KeepTogether property but I have never figured out what that property actually accomplishes. Then the report has GrpKeepTogether property. I can't say if these properties could have some bearing in your situation.

[talktime]

i made a little change in report, i omitted the Page Header section and move it to Student ID header, now it prints two records per page. but when the unpaid list exceeds to 5 and more it prints one full record and one half on the page, can i control that if there is less space on the page to print it should move one whole record to next page?

i have used some VBA with little modification of this page
http://www.databasedev.co.uk/report_printing.html

[June7]

Nope, not a clue about that one, never seen any code.