How to display a thick line every N row in the Access report
problem:
How do I display a thick line how to add a line number column to the report every N row in the report?
Reply:
1. Open the report in the design mode, add a TextBox in the report main body, change the Name property to InputID. 2, set the InputID source to = 1; turn the InputID's Running Song attribute to "Over ALL". Note: If this control is displayed to the user, you will get a row number 3 that is automatically growing with 1 to step into steps 3, and finally, enter the following code in the format event of the main body:
Private sub detil_format (cancel as integer, formatcount as integer) = 0 Then me! [Line19]. Borderwidth = 3 'separation line name is line19 else me! [Line19] .borderwidth = 1 End IFEND SUB 4, the preview report can be seen every 5 lines every 5 lines on the report.
