Print 2 records per page in a formated report layout

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am attempting to print 2 records per 8.5x11 page. I have inserted a page
break between records, counting the records and want the resulting layout to
my specifications. The first page prints correctly with proper spacing, but
the remaining records only print one per page and the spacing changes with
each page. Any suggestiong regarding how to align the remaining records?
 
scocean said:
I am attempting to print 2 records per 8.5x11 page. I have inserted a page
break between records, counting the records and want the resulting layout to
my specifications. The first page prints correctly with proper spacing, but
the remaining records only print one per page and the spacing changes with
each page. Any suggestiong regarding how to align the remaining records?
Click to expand...


In many cases, you can easily get this effect simply by
making the detail section tall enough so only two will fit
on a page. If you set the details section's KeepTogether
property to Yes, then you do not need to be precise in the
setting the section's Height.

In some unusualy cases, you may really need to use a Page
Break control nemaed pgBreak at the very bottom of the
detail section. To manipulate it as needed, you also need a
hidden textbox named txtLine with the expression =1 and
RunningSum set to Over All. Then use this code in the
detail section Format event procedure:

Me.pgBreak.Visible = (Me.txtLine Mod 2) = 0
 
Thank you for your response. I may not have explained myself properly. I
have entered the page break counter and do receive 2 records per page. But
I am attempting fill in the blanks on a preprinted form that is 2 per page.
I am having trouble with the spacing of the information from Access. If I
get the top information to print properly then the second record is not
printing correctly and if I get the second record printing correctly, then
the first record is offline. I was even able to get the first page to print
correctly, but then I received a blank page and the remaining records printed
1 per page. I have tried measuring, resizing the controls increasing and
reducing the margins, etc. but so far no success. Any tips or tricks to
controlling where the infromation prints on a page.
 
Getting that kind of thing to come out right is mostly a
matter of trial and error. It hink you should be able to
keep adjusting the detail section Height until you get it
the way you want.

Make absolutely certain that the page break control is at
the very bottom of the section or part of the section (even
if blank) will take up some space on the next page.

Also make sure that you are not using the report header
section or the first page will be different from the other
pages.
 
Back
Top