I seem to be having and issue with the decimal option in access 2010.

The images below demonstrate the problem that I am having, one image shows normal 0's in empty cells within Access 2010, however when this data is moved to a datagridview the number becomes 3 decimal places (0.000).

The final image displays the options that have been selected within the Qty Open field, this is for information purposes to try and get to the bottom of the problem.

The main issue I believe that is causing this is the Scale option in Access, when this is removed the datagridview displays the number without the additional decimal places. However by removing this option disallows me to enter any decimal places.

![1](https://i.stack.imgur.com/kK5ci.png)
![2](https://i.stack.imgur.com/ZZkKX.png)

![3](https://i.stack.imgur.com/0I4zE.png)