Anyone know how I would have the background color change in the Detail section when a record changes?? 

Just one detail section.  Example:

Edited by aeromonte - 03 Mar 2009 at 1:02pm

you can create a running total field say "totrec" and place this in detail section and supress it. while creating the running total field in the evalute option select the "use a formula" write the below formula

previous(<filedname>) <> (filedname) (this filed name which contains the data 123456,123457 of your table).


Now in the section expert of detail section, select the color tab and check the background color. In the formula you can write the following code.


if {#totrec} mod 2 = 0 then
crblue
else
crwhite;

Edited by Savan - 04 Mar 2009 at 1:24am