Shade Every Third Row in Access 97

[Larry R Harrison Jr]

I need to shade every 3rd row--starting with the 1st one--in a
horizontal-like form. Shading one of the specific boxes is enough. It can do
this by checking for "1" in another text box and triggering it that way;
that would be ideal. Lacking that, a sequence telling it to simply start
with the 1st one and then doing it again every 3rd line would work.

Tips? Also, if it were Access 2000 would it merely be a matter of using
conditional formatting and checking for the value of 1 in the other text
box?

LRH

 

[Allen Browne]

Combine Conditional formatting (Access 2000 or later) with the Row Number
code from:
http://www.lebans.com/rownumber.htm

Use the Mod operator to determine the 3rd line (i.e. the remainder after
dividing by 3).

 

[Stephen Lebans]

For A97 you could modify this solution:
http://www.lebans.com/alternatecolordetailsection.htm
Just change it to color every 3'rd row instead of the current method of
every other row.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.