Validation Rule and Cancel button

Hi,

I have some strange problem with validation rule on a text field. Let say i have 2 text field. One of them got a value from a certain table, and the other one is provided for user's input.

What i want is the value in the user input text field must be smaller that those in the other text field. I put the validation rule as

<= [Box1]

which works fine for 2 digit number. But when it reach 3 digit value it gives the wrong result.

As example, I have a value of 50 in the text field. When the user input

30 ---- it will accept the value
52 ---- it will show the error msg box
100 --- it will accept the value ???
510 --- it will show the error msg box

It seems like it doesnt read the last digit of the value. Any idea ???

And i would like to create a cancel button to close a form, since i have the form criteria to do some saving "on close". If i use the command button "leave form" it will still do the saving. Any basic code in implementing the "Cancel" button


Thx for any help

It is becuase you are using text fields and not numeric fields. in text 100 is less then 50

S_