Limiting how many digits are able to be typed into a field

[Shawn Smalley]

I have a form with an editable field that's supposed to take in a max of a 2 digit number. once they press a button, its grabs whatever the user typed in and sends it to a back-end program to be used in a dec(2,0) variable. the form's data source is just a dummy table with the column being declared as (12 AS pkgcount). The button is set to be disabled if the form is in error, but the user can still type in a numbers that's, say, 10 digits long, and the form will think its okay.

Is there any way to limit the field to only accept 2 digits?

[Johnny Major]

I would suggest defining the column pkgcount as a numeric type with a total of 2 digits and 0 decimal places. See the example below:

cast(12 AS decimal(2, 0)) AS pkgcount,

[Shawn Smalley]

It seems that didn't change anything. I'm still able to type in as many digits as i want, it just errors out when i try to press the button since its trying to fit a 6 digit number into a 2,0 field

[Johnny Major]

After changing the data source, did you resave the widget so it captured the changes?

[Shawn Smalley]

That was it, thank you very much!