Conditional formatting on a Running sum field?

[rudeboymcc]

Hi. I'm trying to make a report with a running sum field. At the moment it's a list of payments with a field "amount" which should how much the payment is (control source = [amount]).

So i created a text box, called it "Balance" and made it's control source = [amount], and set running sum to "over group".

The running total works fine like this.

But then when i apply conditional formatting to it (if less than 0 then make text red), all the values become #Name? .

I know the conditional formatting works because Amount has the same and it works fine.

is this a bug in AccesS? (i@m using Access 2007 ).

Anyone have any ideas? or maybe another way of formatting it to red when negative?

 

[Rich]

£#,##0.00[Black];£#,##0.00[Red] as the format property for the control

 

[rudeboymcc]

Perfect! why does this work though?

I'm now having trouble highlighting a row depending on one of the cells. The cell is called "Type", and it can either have "Rent" or "Rent Payment" as a value.

If it's "Rent", i want the row highlighted. iS tehre any way i can do this using your method were you put it in the format? conditional formatting just doesn't want to work .I've tried Expression is [Type] = "Rent", [Type].Value = "Rent", [Reports]![Payments]![Type] = "Rent", and Field value is equal to "Rent".

anyone have any ideas?