Hey all. I have this issue to solve. I made a report based on a very complex query and I now have to number each individual record within the report. I know it is something inside the properties, but I don't know what exactly. Help anyone?
Numbering in a report
- Thread starter Kyriakos
- Start date
allan57
Allan
- Local time
- Today, 06:20
- Joined
- Nov 29, 2004
- Messages
- 336
1. Create an unbound text box in the detail section of the report called txtRefNumber
2. In the vb code of the report add the following:-
Dim intRefCounter As Integer
Option Compare Database
Option Explicit
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
intRefCounter = intRefCounter + 1
txtRefNumber = intRefCounter
End Sub
2. In the vb code of the report add the following:-
Dim intRefCounter As Integer
Option Compare Database
Option Explicit
Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
intRefCounter = intRefCounter + 1
txtRefNumber = intRefCounter
End Sub
R
Rich
Guest
Add an unbound textbox, set the control source to =1, set the RunningSum property to overall
