Alternate Subform/Datasheet row colors (MS Access 97 !!!! ) ??

Pasting a URL that does not return a 404 'The page cannot be dispayed' error message would help.

Hi jimhorn,

I can browse the link ...

HTH,
LSM Consulting (Scott McDaniel)

Been hours looking for this online .. post it to E-E .. then 10 minutes later found the solution:
http://www.lebans.com/alternatecolordetailsection.htm
for anyone who might needed.

thanks for your attention

Got it to go this time.

luis - Thanks for posting the link.  I'll give this a shot myself, as I've been able to do this on reports for awhile now, but not with forms.

-Jim

There is another way of doing this too:
make the Record source of your Form a Query,
In the Query make a field that generats Serial number, lets call it Serial1
Now in the SubForm/Datasheet, use conditional Formating, if Int([Serial1])=[Serial1], then you can do your Formating,
but this method applied to each field individually, so you will have to apply the conditioanl formating to all the fields.

jaffer

No objections.

No objections.