Should be easy, so I hope reply comes fast.

BLeslie88

B Leslie
Local time
Today, 17:08
Joined
May 9, 2002
Messages
228
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.
 
Found answer...

record source = 1

Running sum = over all

= Problem solves.

thanks.
 
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
 
Nice.

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

Codes seems real nice, and could come in handy.
 
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.
 

Users who are viewing this thread

Back
Top Bottom