Coloring alternate rows in a continuous form, AC2000

[Guest]

I have a form that lists the line items for an order in a continuous form,
there's typically 4 or 5 items per order. I want to highlight every other
order to make it more obvious which lines go together.

I did the obvious using Conditional Formatting and got it working...

Expression Is: [OrderId] Mod 2=1

However this has two problems:

1) the numbering is not continuous, so Mod 2 doesn' REALLY work. Also the
user can filter the entries, so in theory every single OrderId might be odd
or even. Can someone suggest a better sort of test for this? The test should
really be "is not the same as the last row", but I can't figure that out.

2) I can only select from the rather awful set of too-bright overly
saturated colors in the Conditional Formating palette. Is there some way to
simply type in a color code or such?

Maury

 

[Dirk Goldgar]

I have a form that lists the line items for an order in a continuous
form, there's typically 4 or 5 items per order. I want to highlight
every other order to make it more obvious which lines go together.

I did the obvious using Conditional Formatting and got it working...

Expression Is: [OrderId] Mod 2=1

However this has two problems:

1) the numbering is not continuous, so Mod 2 doesn' REALLY work. Also
the user can filter the entries, so in theory every single OrderId
might be odd or even. Can someone suggest a better sort of test for
this? The test should really be "is not the same as the last row",
but I can't figure that out.

2) I can only select from the rather awful set of too-bright overly
saturated colors in the Conditional Formating palette. Is there some
way to simply type in a color code or such?

One of these two pages on Stephen Lebans' web site is probably what you
want:

http://www.lebans.com/conditionalformatting.htm
http://www.lebans.com/alternatecolordetailsection.htm