Hi Guys
I am developing an application with Excel as a frontend and Access backend. When in the userform the values get entered and The button is clicked then those values are stored in Access table. If I enter in a textbox a number with decimal point in it then in the table the related field doesn't store the decimal value and just round off the number. The field has "number "data type with 2 decimal points.
E.g if I enter 19.8 in a textbox then in the table the related field will store 20.
Can anyone please tell me why its happening ? I have set number data type of that field with 2 decimal points.
Thanks in advance for any help!!!
Bookmarks