A bound TextBox showing only negative values

  • Thread starter Thread starter Mota
  • Start date Start date
M

Mota

Hi;
In a continuous form i have 2 txtBox named txtPosNu and txtNegNu.Both are
bound to one field named dNu.This field may contain Negative values and i
want txtNegNu show only values less than zero and txtPosNu show only
Positive values.Can i do this?
Thank you for your help.
 
Hi Mota

You can use conditional formatting. In txtPosNu, set the text colour to be
the same as the background if the number is negative, and the converse for
txtNegNu.
 
Thank you.

Graham Mandeno said:
Hi Mota

You can use conditional formatting. In txtPosNu, set the text colour to be
the same as the background if the number is negative, and the converse for
txtNegNu.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

Mota said:
Hi;
In a continuous form i have 2 txtBox named txtPosNu and txtNegNu.Both are
bound to one field named dNu.This field may contain Negative values and i
want txtNegNu show only values less than zero and txtPosNu show only
Positive values.Can i do this?
Thank you for your help.
Click to expand...
Click to expand...
 
Back
Top