Alternating White and Gray Bars (rows)

[Amfine]

I would like to know how to alternate each row of a report with white and gray bars. I am currently using Access 2003.

Any help would greatly be appreciated.

Thanks,
TH

 

[Crowley16]

in the onFormat event of the section, you need to set up some sort of counter, then use counter mod 2 to get an ocillating value of 0 and 1...

use this number in a if statement which toggles the background property of the row.

--------------------
Procrastinate Now!

 

[Amfine]

Thanks for the idea. I'm not sure how to set up some sort of counter as you suggested.

Do you have any recommendations?

TH

 

[traingamer]

See faq703-2684
Doesn't anybody search before asking?

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[Amfine]

Thanks for your help.

TH