Calculated fields showing Type error

[scoe]

Hi



I hope someone can help as I cannot find a suitable solution on the web at present.

I have the following calculation in a field in an access form, the problem is that when [Text16] is empty I am getting the #Type! error and I need it to be blank.
I would be grateful of any suggestions.

=IIf([2PR]>0,[Text18]-[Text16])

Thank you

[ranman256]

It means you are trying to do math on strings.
You can try converting the text boxes to values.

(val([2PR])>0,val([Text18])-val([Text16]))


note: you can rename your boxes to make sense, in the properties, other tab, name
txtTotal, or txtIncome.

[scoe]

Thank you that worked perfectly