Displaying negative numbers in RED

  • Thread starter dunkster via AccessMonster.com
  • Start date
D

dunkster via AccessMonster.com

I have a report in which I want negative numbers to be displayed as -#,###
in RED. The remainder to display in BLACK.
What is the Format property entry I need to achieve this ?
 
F

fredg

I have a report in which I want negative numbers to be displayed as -#,###
in RED. The remainder to display in BLACK.
What is the Format property entry I need to achieve this ?
Click to expand...

Set the Format property of the control to:
#,### [Black];-#,### [Red];0 [Black]

Look up, in Access Help, Format property + Number and Currency
datatype
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Red cell for negative numbers in Excel 1
Left align currency symbol plus negative numbers in red 2
How do I make negative numbers print in red? 4
Negative number alignment 1
How to format negative currency as red with a negative sign? 4
Negative numbers with parenthesis 4
Hide reords in a report 1
Assisgn color to -ve number 2

Top