How do I make negative numbers print in red?

[Guest]

Hi everyone. I have a very simple report in Access 2000 that people want to
see as they would a similar report in excel with the negative numbers showing
in red. How?

 

[Rick Brandt]

Hi everyone. I have a very simple report in Access 2000 that people
want to see as they would a similar report in excel with the negative
numbers showing in red. How?

Use a format property string similar to...

#.00[Black];#.00[Red]

A format string for a numeric field can have four sections divided by
semi-colons. In order they determine the format for...

Positive Values
Negative Values
Zero Values
Null Values

 

[Guest]

Check this link on conditional formatting

http://www.databasedev.co.uk/conditional_report_formatting.html

 

[Guest]

Thank you ) and you too. It was so simple it is embarrassing lol

 

[Guest]

Your welcome, glad I could help.