how to dynamically change display format

T

traveler

I want to display a field as currency but I want the value to appear in red
if the value is negative and 'default color' if the value is not negative.
Is there a way to do this?

Will
 
F

fredg

I want to display a field as currency but I want the value to appear in red
if the value is negative and 'default color' if the value is not negative.
Is there a way to do this?

Will
Click to expand...

You can use the control's Format property to do this.
Set the Format property to:
# [Black];-# [Red];0 [Black]

Look up Format Property + Number and Curerency datatype
in access Help.
 
T

traveler

Thanks Fred,
That's exactly what I needed.

Will

fredg said:
I want to display a field as currency but I want the value to appear in red
if the value is negative and 'default color' if the value is not negative.
Is there a way to do this?

Will
Click to expand...

You can use the control's Format property to do this.
Set the Format property to:
# [Black];-# [Red];0 [Black]

Look up Format Property + Number and Curerency datatype
in access Help.
Click to expand...
 
Top