<div>
Not really, because the user can change out the sheet at any point.<br />
<br />
One system I work with allows you to input the number of &quot;used&quot; labels, and the printing starts from there. Basically, there is a routine that determines the number of labels available on the sheet. The user enters the number of &quot;used&quot; labels, and the routine then enters blank data for those labels, and starts the &quot;live&quot; labels at the next available. <br />
<br />
So on a sheet of 10 labels (2 columns of 5), if I enter that I've used 3 labels, and I want to print a single label, the routine would enter blank data for 3 labels, live data for a single label, and nothing for the rest. The end result is a sheet with one label in the &quot;4th&quot; position (i.e. the second column, second label down).
</div>


<div>
In addition to Peter's code, you can switch from sheets of labels to a continuous roll of labels.
</div>


<div>
<div class="content wysiwyg-content">
I want to print address labels from a label template using Access 2010. &nbsp;But I don't want to waste any labels. &nbsp;Is there a way to remember what position on a sheet of labels the last label used so the next time it can start with an unused label?<br />
<br />
--Steve
</div>
</div>


I want to print address labels from a label template using Access 2010.  But I don't want to waste any labels.  Is there a way to remember what position on a sheet of labels the last label used so the next time it can start with an unused label?

--Steve

How remember what position on a sheet of labels the last label used

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.