Print a full page of the same Label

[Guest]

I would like to pri nt a full page of the same label. I was able to create a
button on my form so that on click it prints one single address label of the
current record that I am looking at in my personnel database. But what I
want is a full page of the same label and not just one single label. Is
there a way that I can achieve this?

Jessica

 

[Duane Hookom]

Consider creating a table of numbers with a single, numeric field
(tblNums.Num). Add records 1 - the number of labels that fit on a page.

Add this table to your report's recordsource query and don't join it to
anything. You should see many records where there was once only one.

 

[Guest]

Thanks so much. It works like magic!!

Jessica

Consider creating a table of numbers with a single, numeric field
(tblNums.Num). Add records 1 - the number of labels that fit on a page.

Add this table to your report's recordsource query and don't join it to
anything. You should see many records where there was once only one.

 

[Marshall Barton]

You can even use the same technique with the same table to
print as many duplicates as desired without removing any
records from the tblNums table. Just add a criteria to the
Nums column of the query, e.g. <=5 for 5 copies.

Another aspect of this "magical" approach is that you can
even number each copy simply by adding the Num field to the
label.