hi, based on a solution given by rob in
http://www.vbforums.com/showthread.php?t=339978
instead of creating a dummy field in query, we could just create a textbox and set the value when the report runs. so, now my report have a numbering column.
thanks rob
VB Code:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Static idCounter idCounter = idCounter + 1 txtId = idCounter End Sub





Reply With Quote