Text Box Number format problem 1

[Howiee]

I have a textbox which basically sums a couple of the other controls on my form. This sum can either be a whole number e.g. 4, a decimal number e.g. 3.75 or it may be 0. I would like the textbox to display nothing if the sum = 0 and the exact number if it doesn't = 0. i.e. it may display 3.75 or 4 etc. Is there any way of doing this?

Thanks in advance,
Howiee.

 

[DreewToo]

Perhaps try setting the control's data source to a formulae such as =iif([expression]=0,"",[expression]).