CCur Function not displaying as Currency.

[Carpetwarehouse]

I have a calculated field in a report footer which is as follows; CCur(Sum([Line Total]))

Where the answer should be £147.72

Im getting 147.722

Any ideas?

 

[MarkK]

Check the format property of the textbox control that displays the result. Set that to currency.

 

[Carpetwarehouse]

Thanks thats done it!