Value Manupulation

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Arul - 01 Mar 2005 14:51 GMT

Is there a way to replace a negative value with zero. I have a text box that
does some additions and subtraction. If the resultant value is less than
zero, then it should reflect zero. Any ideas?

Reply to this Message

Vaibhav - 01 Mar 2005 16:45 GMT

Have you tried adding a function to the textbox properties ?

> Is there a way to replace a negative value with zero. I have a text box
> that
> does some additions and subtraction. If the resultant value is less than
> zero, then it should reflect zero. Any ideas?

Reply to this Message

ScottD[Interlink Group] - 01 Mar 2005 16:47 GMT

You can use the OnAfterChange event on the textbox to examine the new value
of the field. If it is < 0, set the value = 0.

> Is there a way to replace a negative value with zero. I have a text box that
> does some additions and subtraction. If the resultant value is less than
> zero, then it should reflect zero. Any ideas?

Reply to this Message