report layout problem

  • Thread starter Thread starter Kevin
  • Start date Start date
K

Kevin

hi,

I tried this yesterday and no one responded so I am thinking this is a very
stupid question or no one understood my question. I've done some looking on
my own, but can't come up with any help.

Basically I have a diploma like certificate template that has 2 certificates
per 8x11 sheet. I am trying to lay out a report to fit that template. While
I am able to lay the controls out to print a successfully line-up
certificate, I cannot get the report to print 2 separate records to a
page -- it merely repeats each record on each page so that I end up with 2
certificates for each student.

Labels obviously print in this manner, why won't a certificate template like
this? Do I need to create another section for the second record? Is it a
matter of using VBA to get it to allow 2 separate records per page?

Any helpful thoughts would be appreciated.

Kevin
 
Kevin said:
Basically I have a diploma like certificate template that has 2 certificates
per 8x11 sheet. I am trying to lay out a report to fit that template. While
I am able to lay the controls out to print a successfully line-up
certificate, I cannot get the report to print 2 separate records to a
page -- it merely repeats each record on each page so that I end up with 2
certificates for each student.

Labels obviously print in this manner, why won't a certificate template like
this? Do I need to create another section for the second record? Is it a
matter of using VBA to get it to allow 2 separate records per page?
Click to expand...

This should be very simple. Make sure that you have no
header or footer sections. Add controls (textboxes) for a
single certificate to the detail. Set the detail section's
KeepTogether property to Yes and Force New Page to No. Size
the detail section to half the height of the paper less
margins or a little less.

That would not explain why you're getting two copies of the
same data. Either you have done something funny in the
report or the report's record source query actually has two
records with the same data.
 
Your question was a little short on detail, so we don't quite have a clear
picture of how you have structured your report. But, from the result you
describe, it would appear that you have created a detail section that is a
whole page long, with the bound controls on that page twice, e.g., if you
have two text boxes in your layout for, say, First Name, and two for Last
Name, this is likely the case..

If so, create a detail section that is half a page long, containing the
Controls only once, and play around with size and spacing until you get two
certificates as you want.

If not, please clarify here in the newsgroup, not by e-mail. Thanks.

Larry Linson
Microsoft Access MVP
 
Back
Top