On Sep 8 2004, 12:04 pm, "pete johnson"
wrote:
Microsoft Knowledge Base Article -231801
kb atricle #231801deals with skipping used labels which would normally be
wasted if you print on part of a sheet of labels. it claims that it is foraccess2000. i just used it onaccess97 and it worked perfectly, the first
time, every time.

http://support.microsoft.com/kb/231801

#231801 is a very useful article..

But, it can be made even better by making it even more generic...

Replace STEP 2 Statement, From This:

=LabelLayout(Reports![MyLabels])

To This:

=LabelLayout([Report])

This way it is so generic that you don't have to change the report
name for each reports... Hope this helps...

Please correct me if I have done something wrong... it looks working
to me so far with this change..

And, it works on Access 2003 as well.


---

I learned this trick while reading through:

http://allenbrowne.com/AppLogDocUse.html