How do I... Start an Access label report with any label on the sheet?
Source: Susan Harkins
Printing labels is a snap using Microsoft Office Access' Label Wizard. Depending on the criteria, the report prints the most up-to-date data in the order you need. The only problem is wasted labels; seldom will a report use all of the labels on the last sheet. You probably just throw the last sheet away. With a little help from Visual Basic for Applications (VBA), you can use those partially used sheets. A little code is all you need to start the label report at a specific position rather than at the top of the sheet. Microsoft Office expert Susan Harkins shows you how it is done.
This download is also available as an entry in the TechRepublic How do I... blog.