Decimal Places in calculated field

[treva26]

I have some calculated fields in my form.
They are Standard or Fixed format numbers, with 2 decimal places.
But when I put my cursor in those fields they show lots of decimal places.
Why is that and how can I stop it?



In the attached database its the SELL, MARGIN, and MARKUP fields in the MARKUP form.

 

[MStef]

Hello tlancaster!

In VBA Sub grossmarginbox_AferUpdate()

Me.[Quote Sell Value] = Round(-(100 * [Quote Cost Value]) / ([grossmarginbox] - 100),2)

Me.[markupbox] = Round((([Quote Sell Value] / [Quote Cost Value]) - 1) * 100, 2)

 

[treva26]

Beautiful, thank you!