Print a full page of the same Label

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

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
 
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.
 
Thanks so much. It works like magic!!

Jessica

Duane Hookom said:
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.
Click to expand...
 
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.
 
Back
Top