How to print a full report twice on one sheet of paper

[saudkazia]

I know this has been asked many times but for some reason I can't seem to find a working solution. What do I need to do to print the Northwind Invoice (as an example) twice on one sheet of paper. My printer allows multiple sheets in one page and prints the report in half a page but does this in two sheets of paper which is not the desired result. How do I tackle this. The report is to be printed in landscape mode twice on one sheet of paper.

[June7]

If it's been asked, I've never seen it.

Apparently it is possible in Word. It can be set to Print two pages to a sheet, in print range, enter 1,1 - then you will get two prints of page 1 on the one sheet.

In Access, it is possible with VBA to force report to repeat a record. This may be the only way to get what you want. https://support.microsoft.com/en-us/kb/207664

[saudkazia]

Thanks. Will try and let you know

[June7]

I do have doubts that will work.

Another approach just occurred to me. It involves sizing the report to 11 x 17 landscape and creating 2 sets of controls bound to the same fields, position the sets side-by-side.

[saudkazia]

yeah the problem with that is that I need the headers as well and on top of that I have lines printed through vba. don't know how that will work

[June7]

The header controls would also be duplicated.

The lines are line controls?

[saudkazia]

its for this - https://www.accessforums.net/showthr...7&goto=newpost