Should be easy, so I hope reply comes fast. (1 Viewer)

[BLeslie88]

Need numbering of details.

1-

2-

3-

4-

for each detail line. I did a search can't find answer. Been a long day, can I get a fast easy answer. My old job I had this code, dumb me didn't keep my best secrets... lol they didn't let me keep templates....

on the reports... details... in case it wasn't obvious sine it's under this forum.

 

[BLeslie88]

Found answer...

record source = 1

Running sum = over all

= Problem solves.

thanks.

 

[indyaries]

You can also highlight each line with alternating yellow or some other color.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Const vbYellow = 65535

If Me.CurrentRecord Mod 2 = 0 Then
Me.Section(acDetail).BackColor = vbYellow
Else
Me.Section(acDetail).BackColor = vbWhite
End If
End Sub

 

[BLeslie88]

Nice.

Where would you call this sub...???

Codes seems real nice, and could come in handy.

 

[Pat Hartman]

You can tell by the sub header line:
Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
That the sub is the Format event of the Detail section.