printing sequential labels

  • Thread starter Thread starter tmashburn
  • Start date Start date
T

tmashburn

Guest
I am trying to print labels sequentially by creating a report. I need to be able to enter a "starting label" number and the report then show the next 20 labels/numbers. I then need to print out each one of those numbers on a separate 3X5 label. Any help is appreciated.
 
I just found the answer to this myself. Hope it's not too late for you. Creat an unbound control on your report and set the properties to:
Name to NextNo
Visible to No
RunSum to OverAll
ControlSource to =1

Now set up the control or unbound control you want to sequentially update with an expression like =[LastNo]+[NextNo]. You can set the formatting if you like. This will prompt the person running the report to enter a number and then the report/labels will increment from there.
:D
 

Users who are viewing this thread

Back
Top Bottom