Changing text color of negative numbers in a form

[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

 

[Guest]

Check out Conditional Formatting.

 

[fredg]

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

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

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