a (to) simple format question

hello,

it concerns the following question:

i would like to format negative numbers(money format) as red and positivs as black(without sorting and in the same column).

something like:

IIF(Fields < 0 , red, black)

thx

You've pretty much got the answer.

Set the BackgroundColor property of a textbox to the follofing expression

=Iif(Fileds!your_filed.Value < 0, "Red", "Black")