<div>
Got that. &nbsp;But I also get an error... &nbsp;&quot;The espression you entered has a function containing the wrong number of arguments&quot;.<br />
<br />
??
</div>


Got that.  But I also get an error...  "The espression you entered has a function containing the wrong number of arguments".

??

<div>
check again what you have ...
</div>


<div>
Here is exactly what I have... (copy and paste)<br />
<br />
=IIf([txtTotalPartNQtyNeed<wbr />ed]-[txtTo<wbr />tAvail])=&lt;<wbr />0,0,[txtTo<wbr />talPartNQt<wbr />yNeeded]-[<wbr />txtTotAvai<wbr />l]) 
</div>


Here is exactly what I have... (copy and paste)

=IIf([txtTotalPartNQtyNeeded]-[txtTotAvail])=<0,0,[txtTotalPartNQtyNeeded]-[txtTotAvail])

<div>
Just a tip...<br />
<br />
For syntactical issues in control sources like this, you can put the expression in the VBA editor like this:<br />
<br />
x = IIf([txtTotal PartNQtyNeeded]-[txtTotAva<wbr />il] &lt;= 0, 0, [txtTotal PartNQtyNeeded]-[txtTotAva<wbr />il]) <br />
<br />
Doing so makes it easier to track down errors (the expressions turn red if the syntax is off).
</div>


Just a tip...

For syntactical issues in control sources like this, you can put the expression in the VBA editor like this:

x = IIf([txtTotal PartNQtyNeeded]-[txtTotAvail] <= 0, 0, [txtTotal PartNQtyNeeded]-[txtTotAvail])

Doing so makes it easier to track down errors (the expressions turn red if the syntax is off).

<div>
<div class="content wysiwyg-content">
I am having a problem with an IIf in a text box control source. &nbsp;What is wrong with this code?<br />
<br />
=IIf([txtTotal PartNQtyNeeded]-[txtTotAva<wbr />il])=&lt;0, 0, [txtTotal PartNQtyNeeded]-[txtTotAva<wbr />il])<br />
<br />
--Steve
</div>
</div>


I am having a problem with an IIf in a text box control source.  What is wrong with this code?

=IIf([txtTotal PartNQtyNeeded]-[txtTotAvail])=<0, 0, [txtTotal PartNQtyNeeded]-[txtTotAvail])

--Steve

Problem with IIf

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.