I'm trying to insert a value from TextBox into Access DB (Office 2007). This is a currency value (euro) with 4 decimal places.
A DB column is formated as Currency, ¬, 4 decimal places
A column in DataSet is formated as System.Decimal
Finally, a TextBox is binded to a DataSource and formated as Cyrrency (euro) with 4 decimal places (see attached image).
When I update a table adapter to the DB the value is rounded (31,2345 becomes 31,0000). I would like to preserve a value of all 4 decimal places.
If I edit this value in DB manualy, it compares correctly in software's form.