Print same Reciept 3 times on a Page

[ellenricca]

Hi,

I have an Access 2003 db that is used to enter parking ticket info when
the ticket is paid. The data is entered via form, and on that form is
a command button that prints the Receipt Report for the current record.
That works fine. However, I need to have the receipt repeat itself a
total of 3 times on the printed page (8.5 x 11 sheet, perforated twice
at 3.23in). I added this bit of code (below) that I found on this
newsgroup and it does print the report 3 times, but on 3 individual
sheets, which is not what I need. I need it to print the report 3 times
on the same page. Any help is appreciated...thanks!

Private Sub Command32_Click()
On Error GoTo Err_Command32_Click

Dim stDocName As String
Dim iCounter As Integer
For iCounter = 1 To 3
stDocName = "rptParkingTicketReceipt"
DoCmd.OpenReport stDocName, acNormal
Next

Exit_Command32_Click:
Exit Sub

[AP]

Maybe try making 3 copies of the report (with a different name) and
embedding them as subreports on an unbound report?

[inkman04]

Hello,

If the data is to be the same everytime on the
report, why not just put the same controls on
the report three times into the locations they
need to be?

Just another two cents worth.

Regards

[ellenricca]

Thanks for the idea! I think that will work.