Too many decimal places (15) when clicked!

[XelaIrodavlas]

Hi all,

Sorry if this is a really dumb thing to ask, but I can't get my control to stop showing all the decimal places when the user clicks on it.

To be clear, I have a text box showing an average price. I have set the format property to currency and set decimal places to 2, which appears fine at first glance. However, I have a tendency to click on the things i'm looking at, and when I do it shows me the full 15 decimal places - and it's really bugging me :banghead:

Anyone know a quick fix? Am i missing something obvious? Or should I just man-up and stop clicking on locked controls?

Thanks all

 

[pr2-eugin]

Fix the Query, use Round() method to limit the number..

 

[XelaIrodavlas]

Thanks as always, my sanity is saved.

Edit: Oh except it's still removing the £ symbol and not showing the final zero if it's something like £1.90 - but I should be able to fix that in the query too...

 

[pr2-eugin]

No problem Alex ! Good Luck !