Using IFF function in textboxes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tsison7 - 31 Dec 2007 04:43 GMT

I want to evaluate an equation based on (2) existing variables on a form and
to avoid a division by zero error I was hoping to use the Iff function in the
textbox.

I tried using the IFF function in a textbox as follows Iff(den<>0, num/den,
0) but I take it that function doesn't work in a textbox. Any suggestions on
how to accomplish this by other means?

Signature

TIA

Reply to this Message

tsison7 - 31 Dec 2007 04:47 GMT

Again...nevermind....IIF.....not IFF.....long day....sorry

Signature

TIA

> I want to evaluate an equation based on (2) existing variables on a form and
> to avoid a division by zero error I was hoping to use the Iff function in the
[quoted text clipped - 3 lines]
> 0) but I take it that function doesn't work in a textbox. Any suggestions on
> how to accomplish this by other means?

Reply to this Message