Printing Labels

[Guest]

I've used the label wizard to format a report to print labels; however, I
want to print the same label on the whole sheet. Can anyone tell me how to
format the report to do that? Thanks...

 

[SA]

Don:

There's no way to "format" the report to repeat labels. You have to do it
using VBA code. Lets say you have 12 labels on the sheet.

Dimension a variable in the report module's general section

Dim bCounter as Byte 'Initialized at 0

Then in the On Print Event of the Detail Section of the report add code like
to an event procedure:

If bCounter < 11 Then 'Account for 0 initialization
Me.NextRecord = False
bCounter = bCounter +1
Else
bCounter = 0
End if