Conditional format
Seabird wrote:
I have a report with a conditional format that works fine on the "left" page
but I created a report with the same format (the right page) and it won't
work.
It is a simple line count from a hidden field called "rulenumber"
Rulenumber =1 and not visible.
The conditional format for the whole line is: Right([rulenumber]/2,2)".5"
This creates alternating Background colors for the lines.
For some reason this only works on report 1 (left page) and not on report 2
(right page).
Did you forget to set the text box's RunningSum property?
BTW, the standard expression to test for an even line number
is:
[rulenumber] Mod 2 = 0
--
Marsh
MVP [MS Access]
|