conditional formatting

[azhar2006]

Hello all
I want to write a condition in a text box (conditional formatting)
He
If the value (zero) is the color of a text box and Green if more than (zero), the color red
Please Help


Thank you

[ranman256]

In the ON_CURRENT event (when the user moves to a record)

if txtBox = 0 then
  txtbox.forecolor = vbGreen
else
  txtbox.forecolor = vbRed
endif

[pbaldy]

Or use Conditional Formatting, on the ribbon. It will look better on a form in Continuous or Datasheet view.

[azhar2006]

Thank you very much ranman
In the above code change the font color and not the color field
...................................
Professor pbaldy
What is the expression that we write in (Conditional Formatting) ?

[pbaldy]

Along the lines of

[FieldName] = 0

or

[FieldName] > 0