Calculated Field on a Form

[LisaG]

I have a calculated field on a form - =Sum([Exc VAT]) - and although it will
calculate the sum of the required field, it ignores the digits after the
decimal. Why is this and how can I fix it? It happens with all my sum
fields.!

 

[fredg]

I have a calculated field on a form - =Sum([Exc VAT]) - and although it will
calculate the sum of the required field, it ignores the digits after the
decimal. Why is this and how can I fix it? It happens with all my sum
fields.!

Most likely you have set the control's Decimal Places property to 0.

Set the Control's Format property to Standard (or Fixed).
Set the Decimal Places property to 2.
Both properties are found of the control's Property Sheet's Format
tab.

 

[lisag]

I have a calculated field on a form - =Sum([Exc VAT]) - and although it will
calculate the sum of the required field, it ignores the digits after the
decimal. Why is this and how can I fix it? It happens with all my sum
fields.!

Most likely you have set the control's Decimal Places property to 0.

Set the Control's Format property to Standard (or Fixed).
Set the Decimal Places property to 2.
Both properties are found of the control's Property Sheet's Format
tab.

Thanks, but I have made sure that all the properties are set to standard
with 2 decimal places, and done this for the fields the control calulates
from etc etc but to no avail!