Problem:
How do i show a thick line every n rows in a report
How do I add a row number column to a report?
Reply:
1. Open the report in the design mode, add a TextBox inside the report body, and change the Name property to inputID.
2. Set the inputID Control Source (ControlSource) property to = 1, and then change the inputID's running sum (RunningSum) property to "above all" (overall).
Note: If you show this control to the user, you will get a row number that is automatically grown with 1 stepping
3. Finally, enter the following code in the format of the subject:
The following are the referenced contents: Privatesubdetail_format (Cancelasinteger,formatcountasinteger) If (me![ INPUTID]MOD5) =0then me! [Line19]. Borderwidth=3 ' separator line is named Line19 Else me! [Line19]. Borderwidth=1 EndIf Endsub |
4, preview the report can be seen on the report every 5 lines show a line of thick lines.