Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

show same record twice on each report page 2

Status
Not open for further replies.

abbottboi

IS-IT--Management
Nov 14, 2005
94
CA
Hi,

I have a small database for a charity. It contains records of donations made by donors. I would like to make a report that i can use to print receipts but would need it to print each record twice on one page..meaning two of each field name showing. so that there is two receipts on each printout.

My question is how can i show the same field of the same record twice. ie
Code:
First_name
at the time and bottom on the same report page?

Thanks again!
 
Here is one way

Dim blnMove As boolean

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
If Not blnMove Then
Me.NextRecord = False
End If
blnMove = Not blnMove
End Sub

 
where do i put that?

i need each field tos how twice in each page.. so first_name top and bottom.. Last_name.. etc

thanks
 
I believe MajP's suggestion will actually print the same page twice. If you want it on the same page both times, just copy and paste every field.


Randy
 
Oops. Did not see you wanted 2 on the same page. The above will print the record twice on a continous form or 2 pages. Do what randy said.
 
Yeah.. thanks Randy!!!

i totally didn't think of using the same field twice.. but i got it. was a sloo friday fer me.

thanks again!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top