Mark every 3rd row

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would like to get 3 row with grey backround and next 3 rows transperent/non
background or a line/underline every 3rd row
 
Add a text box to the report, and set these properties:
Control Source =1
Running Sum Over All
Visible No
Name txtCount
Format General Number

Add a text box the size of the Detail section, behind the others (Format |
Send To Back). Then choose Conditional Formatting on the Format menu, and
set Condition 1 to:
Expression: (([txtCount] - 1) Mod 6) < 3
and choose the grey in the bucket.

The running sum accumulates 1 for each record.
Mod gives the remainder after division.
If the remainder is 0, 1, or 2, the expression is true, so the text box is
grey.
 
Back
Top