Alternating Row Colors for Subform in Access 2002

[bell]

Hi all,

I've been doing a little research on this subject and cannot find anything I need for Access 2002.

I have a subform that displays info in datasheet view, and I would like to have the colors alternating for each row of the subform, so when I print the report out its a little easier to follow the table.

I found info about about using Alternate Back Color, but I can't find this field in Access 2002.



Can anybody help me with this one?

[rpeare]

it's not available in access 2003.

I do not know if this will work on a form (it does on reports)

Create a field on your form with the control source =1, name the field LineNumber, set the property to RUNNING SUM
Open your form
You should see a field with an incremental number.

If that works
create a text box that covers your detail area, send it to the back, and put conditional formatting on that field of

EXPRESSION:

[LineNumber] mod 2

Select the color you want for the alternate row from the back color palette.

Open your form again, if it works like a report you should see alternate row shading.

If the running sum is not available on forms (I don't think I remember it being so) you can artificially create a linenumber using this:

http://www.tek-tips.com/faqs.cfm?fid=5248

except you would be using a static value (1) instead of summing a value.

[Missinglinq]

...I do not know if this will work on a form (it does on reports)...

...if it works like a report you should see alternate row shading.

...If the running sum is not available on forms...

Since the OP stated

...I would like to have the colors alternating for each row of the subform, so when I print the report out its a little easier to follow...

I don't see where there's a reason to be concerned with doing this on the Form; colors displayed on a Form should have nothing to do with colors displayed on a Report, as Forms should never be printed out!

This being said, rpeare's code, if intended for Reports, as stated, should work just fine!

Linq ;0)>