Printing 2 pages per page by coding

Spierce

New member
Local time
Today, 07:53
Joined
May 23, 2014
Messages
2
Hello all,
I have inherited a database that we have been using for a long time because the person who designed it retired, and I'm the only other person in our company that *somewhat* speaks Access.
We have one report that when it prints, it only fills the top half of the page and we end up cutting off the bottom and wasting paper. I wanted to change it so that the report would print 2 of the report pages per page, without using printer settings as our printer does not do duplex and it would not be practical to manually flip the sheets due to the location of the printer relative to our computers. I have an image of this attached (print preview) with the red text being what we would like to see.
I have also included a screen shot of the design view for the print preview as it currently is.
I really am not sure where to go from here. I have some basic VB knowledge, and have made a few fairly simple databases myself, but have no formal training in the area. Any help or suggestions would be greatly appreciated.
Thanks!
 

Attachments

  • print preview.jpg
    print preview.jpg
    91.3 KB · Views: 136
  • design view.jpg
    design view.jpg
    99.7 KB · Views: 123
I have tried the sorting and grouping, but am afraid that nothing I tried worked. It needs to re-display the header as well as the detail for the next record page on the lower half of the page. Most suggestions I have found on the web are for displaying multiple details per page, but they do not re-display the header, or they are for duplex printing which we are not capable of.
Perhaps I am trying to chase something that it is not capable of, but I hope not.
Thanks!
 
Have you tried moving the info in the page header to the detail section.
 
ya AccessBlaster but he required to fill up the data twice per page

So I think well, in all textboxes there's a property "Hide Dups.."

If we turn to yes, then will it create duplicate set of formatted reports
 

Users who are viewing this thread

Back
Top Bottom