Stop (-)ve values showing in calculated control 1

[james33]

I have a calculated control on a Hire Database form and it arises from a situation where the Deposit is not sufficient to cover the HireSubTotal.
It is exacerbated by the VAT which is added to it afterwards as well because that shows up as a negative number too.
How can I leave blank the calculated HireTotal Control when this situation occurs?
In advance thanks for any Help
Jim

 

[JimHorton]

Jim,
You can use the ubiquitous Inline-If, or IIF() function, change the calc'd control source to:
=IIF([YourOriginalCalc]<0,&quot;&quot;,[YourOriginalCalc])
--Jim