Conditional format with Running sum

[WineSnob]

I have a report that has a field with running sum over the group. When I try to set the Conditional format to RED BOLD for negative values I get an error. The current format for the text box is currency.
How do I set the conditonal format for running sum text box?
Thanks.

 

[Brianwarnock]

I think that you do it the same as for any other control.

OOps Brain into gear

Normally for a running sum you set the control source to say field1 and then set the running sum property, however this gives a #name error when doing conditional formatting, what you do is set the control source to =[field1] and bingo it works

Brian

 

[WineSnob]

I tried that. The textbox next to it works fine. There is something? about it being a running sum.

 

[boblarson]

What is the exact expression you have used? And when you are trying to check for negative, is it the Running Sum that is negative or the value being added to the running sum?

 

[WineSnob]

Field value is less than 0 then apply format. I am trying to apply the format to the running sum field. The value being added to the running sum is both negative and positive and the conditional format works fine on that field.

 

[Brianwarnock]

I have edited my response without realising there were further posts.

brian

 

[WineSnob]

Brian and all.... The field being used is called [Cash Flow] the running sum field is text26. [Cash Flow] is formatted and works fine. You are right I get the #name error when I try to format [text26]. The control source for [text26] is [Cash Flow]. Is that what you mean by setting the control source to =[field1]?

 

[Brianwarnock]

yes you presumably have text26 control source as [cash flow] place = infront of that.
=[cash flow]

Brian

 

[boblarson]

The field being used is called [Cash Flow] the running sum field is text26.

First off, let's get some terminology straight. text26 is NOT a field. It is a CONTROL. Controls are on forms and reports and Fields are in tables and queries. This is an important concept to keep track of as it can make or break the answers given or how the question is asked.

 

[Brianwarnock]

Bob as usual you are correct, it is the name of the control that is used in the running sum. I guess that for most they are the as same the field in the query as that is what the wizards do.

Brian

 

[WineSnob]

Brian - Thanks. That worked.....
Bob - My mistake you are of course correct it is a control and not a field.
Thanks to ALL

 

[boblarson]