I want the colour of a value to change to red if it's a minus, other wise I want it to be black. I've tried using VB with an If statement and the me.value.forecolor command but it changes the colour of the entire column. Anybody got any ideas cos it's really doing my head in.

In your table, type this in "format" for your currency field:
$#,##0.00[Black]; ($#,##0.00) [Red]

this will make all positive currency numbers black and negative numbers red.
Hopefully this will help!

Format:###[Black];###[Red]

If the number is longer put more #'s

Hope that works

Is it possible to change the colour of a text field when a number field (in that record) is minus?