View Single Post
  #2  
Old July 30th, 2007, 09:18 PM posted to microsoft.public.access.reports
Marshall Barton
external usenet poster
 
Posts: 5,361
Default 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]