Changing text color of negative numbers in a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form with both negative and positive numbers in a field. I want to
be able to change the negative numbers to red and leave the positive numbers
black. Is there any way to do this?

I am using Access 2003.

Thanks!

David
 
I have a form with both negative and positive numbers in a field. I want to
be able to change the negative numbers to red and leave the positive numbers
black. Is there any way to do this?

I am using Access 2003.

Thanks!

David
Click to expand...

Set the control's Format property to:
#[Black];-#[Red];0[Black]

Look up the
Format property + Number and Currency datatypes
in Access Help.
 
Back
Top