If I put 99990.99 in the input mask, then the user has to arrow over to after the decimal point (is this because the value is a text value). This would make the users mad.

I can't change the database field type (MSSQL) since I don't own the database schema.

Kirk


>What about 99999.99
>>
>>I have a text field for collecting weight that I need to allow the user to input into. I initially set the input mask for the text box to 99999 and max field length to 5. This works until they have to enter a value of 91.17.
>>
>>If I max the input mask ##### then they can enter enter blanks (and my users have) which screws up converting that value to a numeric later for processing.
>>
>>I have to allow for the decimals. Should I use ##### and then do a STRTRAN afterwards and remove any blanks. I'm not sure that this will help ensure the right data was entered since they shouldn't have entered any blanks to begin with. That was why I went with the 99999 format.
>>
>>Thanks for your thoughts and suggestions.
>>
>>Kirk