Continous form text box color change

  • Thread starter Thread starter martin
  • Start date Start date
M

martin

I have a textbox that has a number in it on a continous
form. I would like to make the # red if its negative and
black if its positive. I have been able to change color of
the text box based on the 1st # on the form but it doesn't
change back when needed. Any Suggestions?

Thanks
Martin
 
Use the format property of the text box control to alter
the color from record to record.

eg)
$#,##0.00;($#,##0.00)[Red];"Zero";"Null"

This example has 4 parameters separated by semi-colins.
param 1: positive values
param 2: negative values
param 3: zero values
param 4: null values

Placing a color in brackets in the appropriate param will
alter the color of the text accordingly. Place your
cursor on the format property of a control and press 'F1'
to see more on this. Good luck.
 
I have a textbox that has a number in it on a continous
form. I would like to make the # red if its negative and
black if its positive. I have been able to change color of
the text box based on the 1st # on the form but it doesn't
change back when needed. Any Suggestions?

Thanks
Martin
Click to expand...

To change just the font color all you need do is set the Format
Property of the control to:
#,##0.00[Black];-#,##0.00[Red]
 
Back
Top