CODEWITHSUNDEEP
ms-access
SaraniO
SaraniO

Reputation: 607

how to make data in access to only have 2 decimal number

I think this might be a simple question but I don't know what's the answer

in access 2013 for my calculated field using Field properties I Set Format = standard and decimal place = 2,

and it shows the number with 2 decimal, but when I click on the field or when I want to show them in a datagridview in C# the number displayed with different decimal number. what should I do to round the number?

Upvotes: 1

Views: 2188

Answers (1)

AVG
AVG

Reputation: 1462

The format property of a field has no effect on how the data is stored. If you want it displayed a certain way in your application, then you must format it in your application. The Winforms Datagridview column has a defaultcellstyle.Format property https://msdn.microsoft.com/en-us/library/f9x2790s(v=vs.110).aspx.

Upvotes: 2

Related Questions