Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 517
  • Last Modified:

Problem with decimal number insert into Access DB

Hi,
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.
09-10-2008-21.23.00.jpg
09-10-2008-21.48.06.jpg
0
minjakon
Asked:
minjakon
1 Solution
 
Gustav BrockCIOCommented:
The default count of decimals is zero:

http://msdn.microsoft.com/en-us/library/xtba3z33(VS.80).aspx

You may need to adjust that to four.

/gustav
0
 
minjakonAuthor Commented:
Yes, that was it!
I used Double instead of Decimal
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now