Servoy version: 6.1.4 i1.
We are applying format over a field so that it should only accept numbers of length 8. Format is applied on table level. Data type of column is number in database.
Display/Edit format that has been used is ########. Now the problem is, it allows user to input -, % and $ sign. In order to prevent user from inputting negative number we also used NumberRangeValidator on the same field. Although we prevented -ve numbers but problem comes when user tries to input something like '123-456'. It truncates string '-456' leaving just '123' behind. Is there format mask available that will not let user input something like this at first place. Is there a way we can force user to input only numbers in the field using format.
Thanks,
Anuja