Displaying negative numbers in RED

  • Thread starter Thread starter dunkster via AccessMonster.com
  • Start date 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 ?
 
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
 
Back
Top