One label filling entire sheet of labels?

[dibeach]

I have created a query and report to generate a label for just one contact. Now I want to print a whole sheet of that one person. Is there a way to do it?

Please be gentle - I am learning Access!

 

[Jn88]

Put this code in the Detail onFormat Event:

If FormatCount < 30 Then Me.NextRecord = False

30 stands for the amount of labels you want to print Hope this helps if not let me know

Jn88
Jn88@att.net

 

[dibeach]

I put the code you suggested, where you suggested but when prompted for the parameter value, message was that the macro If FormatCount < 30 Then Me.NextRecord = False
could not be found. Any advice please?

 

[Jn88]

Don’t put the code in the property window!
Select event procedure and invoke the code builder and past the code in the code window
Hope this helps if not let me know

Jn88
Jn88@att.net