This is an option, but I don't like the idea of showing a zero, and I would have to add some extra validation to remove the zero and replace with an empty string. Empty is valid, zero for the weight is not.
This may be my best option, I just wanted to check to verify that I wasn't missing another formatting option.
Kirk
>>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
>>
>
>I suggest to use unbound numeric field in VFP and use replace manually to bind it.