BillyBoyo wrote:With only 0-9 comma and full-stop/period then NUMVAL should not be a problem. What is the problem you have with NUMVAL?
You should look at what JUST RIGHT is doing for you. With fields of the same length, the answer is nothing, so I assume you think it is doing something else.
NUMVAL works fine. But if the user inputs any alphanumeric in the field, then it fails. I have to put a check for that. (Client says user is dumb and can give anything!!)
I have used just right at the amount value can be anything from 999,999,999.00 to 0.00
and he can enter anything. if its a number, i have to accept it!!