>Hi,
>I am having a problem when trying to enter a numeric value into a txtbox. The length of my database field is ,let say, 10 numeric and 2 decimal and the size of the txtbox on the screen is much bigger so it can get greater number. I don't use any mask for my field because I want to enter either 9999999.99 or 9999999999. My question is: how can I check for the input, because when i enter a very big number I get an error saying numeric overflow. Is there any way? I tried converting to char but it didn't work.I know that my get object on the screen has to be as big as my field's size. How can I check how many digits I entered?
>Thank you very much.
>Vlad

IMO, Textbox.Inputmask="9999999.99" is natural for N 10.2 field. It doesn't matter will user enter decimals or not. If you want to allow entering bigger number, e.g. 9999999999 then the first thing you should do is to change table field (controlsource) width.