Results 1 to 4 of 4
  1. #1
    dwilson is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Location
    Indianapolis
    Posts
    22

    Report print two records per page

    I am designing a report for transportation vouchers, and I need two to print per page. Each voucher is the size of a half page. When I print, it prints the same voucher twice, not two different vouchers. All the fields are set up in the detail section. Each voucher has a separate number.
    I saw somewhere about changing section height in the detail section, but it will not let me change this. Any ideas?
    So when we print say 12 vouchers, we only want each one to print once. There should be 6 pieces of paper with two vouchers printed on each.


    I am attaching a sample of the report screen
    Attached Thumbnails Attached Thumbnails Report screen.jpg  

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Delete the second set of controls and size the detail section accordingly. If the size is right, it will print two per page.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    dwilson is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Aug 2011
    Location
    Indianapolis
    Posts
    22
    Thank you, that worked!

  4. #4
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,640
    Happy to help!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

Please reply to this thread with any new information or opinions.

Similar Threads

  1. =Report won't Print each record on page
    By ashbear in forum Reports
    Replies: 17
    Last Post: 06-13-2013, 04:04 PM
  2. Report doesn't print on 1/3 of the page
    By wubbit in forum Reports
    Replies: 2
    Last Post: 04-17-2012, 07:44 PM
  3. Replies: 3
    Last Post: 08-07-2011, 09:22 PM
  4. Replies: 4
    Last Post: 04-11-2011, 04:25 AM
  5. code to print just first page of a report
    By tonyrice in forum Reports
    Replies: 1
    Last Post: 02-14-2007, 03:07 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums