<div>
What are the values of the textboxes when running the code. I believe the error message tells you exactly what the problem is, your dividing a number by 0.
</div>


What are the values of the textboxes when running the code. I believe the error message tells you exactly what the problem is, your dividing a number by 0.

<div>
try this<br />
<br />
<br />
Me.txtACV = IIF(nz(Me.txtUsefulLife,0)<wbr />=0,0,Me.tx<wbr />tTotalEsti<wbr />matedRepla<wbr />cementCost<wbr /> * (Me.txtUsefulLife - Me.txtCurrentLifeOfAsset) / Me.txtUsefulLife)
</div>


try this


Me.txtACV = IIF(nz(Me.txtUsefulLife,0)=0,0,Me.txtTotalEstimatedReplacementCost * (Me.txtUsefulLife - Me.txtCurrentLifeOfAsset) / Me.txtUsefulLife)

<div>
Didn't work. &nbsp;Still get div by zero error
</div>


Didn't work.  Still get div by zero error

<div>
Dale is correct but interestingly, the IIf() works differently in VBA than it does in SQL. &nbsp;In VBA, all clauses of the IIf() are evaluated and so you get the divide by zero error whether it is in the true path or the false path but if you used the same expression in a query, only the true path is evaluated so you would not get the divide by zero error. &nbsp;Because of this behavior, I almost never use the IIf() in code.
</div>


Dale is correct but interestingly, the IIf() works differently in VBA than it does in SQL.  In VBA, all clauses of the IIf() are evaluated and so you get the divide by zero error whether it is in the true path or the false path but if you used the same expression in a query, only the true path is evaluated so you would not get the divide by zero error.  Because of this behavior, I almost never use the IIf() in code.

<div>
<div class="content wysiwyg-content">
Why am I getting a Division by zero error with this code:<br />
<br />
Me.txtACV = Me.txtTotalEstimatedReplac<wbr />ementCost * (Me.txtUsefulLife - Me.txtCurrentLifeOfAsset) / Me.txtUsefulLife
</div>
</div>


Why am I getting a Division by zero error with this code:

Me.txtACV = Me.txtTotalEstimatedReplacementCost * (Me.txtUsefulLife - Me.txtCurrentLifeOfAsset) / Me.txtUsefulLife

Division by zero error

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.