Re: Printing "3-up" records on a preprinted form

It's fairly easy programming to et Access to calculate the height of each section: subtract double the margin (top + bottom) + a spacer for each detail less one from the page height. You can then programmatically open the report in design view, and set section heights.

You can create a generic function to use in the On Format property of the GroupFooter0 section. It takes an argument indicating the number of labels on the page. So (for example) if it's a 3-up page, you set the property programmatically like this:
rpt.Section(acGroupLevel1Footer).OnFormat = "=MyFunction(3)"

Re your wry smile, I did go metric years ago, but ended up going back to the old Imperial measurements, as twips are not exact multiple of the metric measurements.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Dave Bolt" <dave@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:uK6jbRMRHHA.488@xxxxxxxxxxxxxxxxxxxxxxx
Allen,
I used this, it works just great (when converted to millimetres<wry smile>).
Since I don't do Access very much I thought I should ask if you have a further modification.
We have _lots_ of reports which will need to use one of three variations on the footer event procedure (for three, four or five sections). I just did a quick estimate and we are talking at least 1000 reports already.
I would prefer to be able to have a function or macro for each section count variation once in the database, (in a module?), instead of once for each report. Massive saving on typing and space.
Hope this makes sense, If so, any ideas?
Regards
Dave Bolt

"Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx> wrote in message news:uHfqQ2qNHHA.3552@xxxxxxxxxxxxxxxxxxxxxxx
See:
Print a page with 3 evenly spaced mailing slips
at:
http://allenbrowne.com/ser-54.html

"Tungsten" <Tungsten@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:FC170551-3CDE-48C7-808B-60213DD230D8@xxxxxxxxxxxxxxxx
I am having difficulty printing records three on a page, evenly spaced in my
Access report. I can print single records on separate pages, multiple
records with varying spacing continuously, but I have perforated paper that I
want to use that divides an 8-1/2 x 11 *** into three equally spaced areas
that I want the records to print onto.
Appreciate help

.