Multiple Detail Sections

[Guest]

I am producing a report with a detail section that pulls records from a
single query. I would like to be able to format records 1-10 differently
than records 11-20 in the report and put a separator between the two
sections. Is this possible? (Of course ANYTHING is possible!) How?

thanks so much for the help,
ZT

 

[Marshall Barton]

I am producing a report with a detail section that pulls records from a
single query. I would like to be able to format records 1-10 differently
than records 11-20 in the report and put a separator between the two
sections. Is this possible? (Of course ANYTHING is possible!) How?

Add a text box named txtDtlCnt to the detail section. Set
its ControlSource expression to =1 and its RunningSum to
Over All. Then you can add code to the detail section
Format event to change all kind of things. E.g.

Select Case txtDtlCnt
Case 1 To 10
txtA.FontName = "Arial"
txtA.FontSize = 12
txtA.FontBold = True
txtB.ForeColor = RGB(192,0,0)
. . .
Case 11 To 20
txtA.FontName = "Broadway"
txtA.FontSize = 15
txtA.FontBold = False
txtB.ForeColor = RGB(0,220,0)
. . .
Case . . .
. . .
Case Else
. . .
End Select