>O.K. so I am testing everything in this inventory database and when I open 1 particular form it is adding a decimal point to the record and the table within the .dbc is set for 0 decimal point yet it shows as 1.23 if you will.
>
>I have checked form properties the database 3 or 4 times, what am I missing here does anybody know where I could start on this one?
>
>Is there some way to force the field to not accept decimal etc...... HELP
>

Yes, you can specify input format in the InputMask property.