How do I make negative numbers print in red?

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

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?
 
Terrie said:
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?
Click to expand...

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
 
Back
Top