two records per page??

[DJ44]

Good day.

I am required to print information (like name etc) onto a pre-printed certificate. The pre-printed certificate is 8.5"x 5.5" and there are two certificates per "page" (perforated at the centre).

I have a report that will get all of the required info, however it will only print one record per page, only in the upper certificate.

Any ideas how to get it printing two records a page in the proper location?

Thanks in advance, all help is greatly appreicated

DJ

 

[RichO]

Access reports will print as many records on a page as will fit. This means that with your current settings it can only fit one.

To keep it simple, let's assume that all of your controls are in the detail section with no headers or footers. Take your top and bottom margin settings and subtract them from 11. Then divide the result by 2. Now that result is the maximum size your detail section can be in order to fit 2 records per page. If you are using the default margins of 1 inch, your maximum detail size is 4.5 inches.

Basically you'll need to do some experimenting with the margins and vertical size properties to get the desired results.

 

[DJ44]

Access reports will print as many records on a page as will fit. This means that with your current settings it can only fit one.

To keep it simple, let's assume that all of your controls are in the detail section with no headers or footers. Take your top and bottom margin settings and subtract them from 11. Then divide the result by 2. Now that result is the maximum size your detail section can be in order to fit 2 records per page. If you are using the default margins of 1 inch, your maximum detail size is 4.5 inches.

Basically you'll need to do some experimenting with the margins and vertical size properties to get the desired results.

Thanks for the reply .... it is now more clear how Access treats the page layout stuff. I will experiment.

DJ