The difficult I do immediately, the impossible takes a little bit longer.
Question :
Hi, I am trying to create a full sheet of the same label from my access file. I would like 30 of record 1, 30 of record 2, etc. Is there a way to do that so I get a full sheet of each record rather than just one label of each?

Question :
I need a way to print only 2-3 labels at a time, but not waste the whole sheet of labels. Any ideas?

Answer :
This sample database will allow you to print a full sheet of the same label or print a partial sheet of the same label or use a partially used sheet to print labels or any of the above in combination of each other.

This database requires Access 2002 or above...
To use this database import the Module and the form enclosed in the sample download into your database. Make sure you look at the settings below to get all the parameters in the right place.  There is no need to import the report as you can use your pre-existing label report.

(If you do not want to use the enclosed form (see above) you can place the fields on another form of your choice. BUT where you find a reference to the form and/or field name you must change the name accordingly, including within the module!)
In your Report's Properties, entries must be made in three places…

1. Report Properties - On_Open event...
2. Report Header Properties - On_Format event...
3. Report Detail Properties - On_Print event...

Notice... you will need to put the name of your report within the parenthesis, ie:
(Reports! YourReportName )
If you have elected to use another Form then don’t forget to open the Module and change the Form name to match your own Report name!
Print Full or Partial Sheet of Labels...
In the query attached to your Report on the Criteria line put a reference to your form and the Combo Box where you select which entity you want to print labels for...
Reports
aaaaaaaaaaaaiii