My Currency Format Control Rounds Down

[Drenda]

Can anyone help

I have a control called total cost on my form which has a currency format and displays a calculated result based on two other controls on the same form named quantity and unit cost

I have a macro which sets the value of total cost through

quantity * unit cost

The problem is that no matter what I do the result rounds down and I cannot seem to resolve

So for example if I have a quantity of 2 and unit cost of £1.32 the result should be £2.64 but I get a result of £2.00. I have tried setting decimal places to 2 and auto but it still does not work

Any help would be appreciated

 

[JerryKlmns]

Right click Total Cost, select Properties, on Data tab put this =CCur([quantity]*[unit cost]) to the Control Source

 

[Drenda]

Thanks for you help

 

[JerryKlmns]

Some post on other thread thread705-1428306