If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
Conditional Formatting And Running Sums
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. |
#3
|
|||
|
|||
Conditional Formatting And Running Sums
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. |
Thread Tools | |
Display Modes | |
|
|