On 9 Dec 2005 00:30:46 -0800, solar wrote:
Is there a way that a user can set the position for a single label to
print within an Access Label report? I guess I would like something
like what is available in Word where the user can select the column and
row position for the single label to be printed. I would like to be
able to provide a form where the user selects the column and row
position for the single label or default to the top left label.For
example, the size of the labels on the list is 99 mm x 57 m.
How can i adjust the labels size to the report's design ?
If you use the Report's Label wizard to create your labels, you can
then use the following code to skip labels.
First make sure your label report is properly printing a full sheet of
labels.
Then add a Report Header to your label report.
Add 2 text boxes to the Header.
1) Name one SkipControl
Leave it's control source unbound
2) Name the other SkipCounter
Set it control Source to =[Skip How Many?]
Now code the Report Header Format event as below:
Private Sub ReportHeader_Format(Cancel As Integer, FormatCount As
Integer)
[SkipControl] = "Skip"
Cancel = True
End Sub
==========
Next code the Detail OnPrint event:
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If PrintCount <= [SkipCounter] And [SkipControl] = "Skip" Then
Me.NextRecord = False
Me.PrintSection = False
Else
[SkipControl] = "No"
Me.PrintSection = True
Me.NextRecord = True
End If
End Sub
=====
When you are ready to run the label report, it will ask how many
labels to skip.
Then it will run the report.
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail