report print

S

seeker

The following code is used to place a number in front of a record on a report:


Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer)
intcounter = intcounter + 1
txtNumber = intcounter
End Sub

When the report is on the screen the numbers are correct (1 - 64) but when I
print the report the numbers are 65 - 129. How can i keep this from
happening. When the report opens incounter is initialized to 0.
 
J

John Spencer

Set the control source of TxtNumber to =1 and set the Running Sum
property to Over All

Get rid of the VBA code.

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
'====================================================
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Main Report without Data 1
Cant set controlsource on-the-fly 3
Printing strange symbols between multicopy report 1
Form Filter? "Enter Parameter Value" 1
Access2007 won't run report event procedures (e.g. Detail Format) 2
HOWTO: Suppress Page Header on Print 1
Using a filter to show results on a report 5
HOWTO: Reset Page Header for Each Group 2

Top