Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Colour Negative fields in Report 1
- Thread starter dunkster
- Start date
-
1
- #2
JohnLowell
Programmer
You can use the format property of the text box control.
Try this:
$#,##0.00[Black];-$#,##0.00[Red];0;" "
The format property is broken down like this:
positive value; negative value; zero value; null value
I hope this helps.
Try this:
$#,##0.00[Black];-$#,##0.00[Red];0;" "
The format property is broken down like this:
positive value; negative value; zero value; null value
I hope this helps.
- Status
Similar threads
- Locked
- Question
