Conditional Formatting And Running Sums

I have a report in which I am using a running sum to display the total over grouped sets of values. The running sum is in the details section and the sum is displayed in the group footer.
This sum works correctly. I added a text box that has a conditional formatting applied to it in the detail section. The formatting changes the fill/background color of the text box when the condition is met. The running sum started to display only the first value of the group(in the group footer), rather than the sum. If I remove the conditional formatting the sum is correct. I am using Access 2003. Any advice would be appreciated.

How about using code in the Print event, instead of Conditional
Formatting -- that'll work fine in reports. (Conditional Formatting is a
necessity only in Continuous Forms view on Forms.)

Larry Linson
Microsoft Access MVP

"Michael" wrote in message
...
I have a report in which I am using a running sum to display the total
over grouped sets of values. The running sum is in the details section and
the sum is displayed in the group footer.
This sum works correctly. I added a text box that has a conditional
formatting applied to it in the detail section. The formatting changes the
fill/background color of the text box when the condition is met. The
running sum started to display only the first value of the group(in the
group footer), rather than the sum. If I remove the conditional formatting
the sum is correct. I am using Access 2003. Any advice would be
appreciated.

Thanks Larry. I was fixated on making it work and lost sight of the forest for the trees. I made it an IIF statement in the Format event and it works perfectly.

"No problem can be solved from the same consciousness that created it." - Einstein

----- Larry Linson wrote: -----

How about using code in the Print event, instead of Conditional
Formatting -- that'll work fine in reports. (Conditional Formatting is a
necessity only in Continuous Forms view on Forms.)

Larry Linson
Microsoft Access MVP

"Michael" wrote in message
...
I have a report in which I am using a running sum to display the total
over grouped sets of values. The running sum is in the details section and
the sum is displayed in the group footer.
This sum works correctly. I added a text box that has a conditional
formatting applied to it in the detail section. The formatting changes the
fill/background color of the text box when the condition is met. The
running sum started to display only the first value of the group(in the
group footer), rather than the sum. If I remove the conditional formatting
the sum is correct. I am using Access 2003. Any advice would be
appreciated.