Using IFF function in textboxes

  • Thread starter Thread starter tsison7
  • Start date Start date
T

tsison7

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IFF Function 2
Update field using (Iff) statement. 3
Conditional statement in a text box? 2
IIF statement 1
Iff Function 2
Sum If function in textbox 0
Iff statement to show pictures 4
re Iff function 5

Back
Top