<div>
It looks like the syntax may be off on your statement, you may want this (not worrying about data types for a minute...).<br />
<br />
Me.txtDollarsPerHour = IIf(Me.txtActualHours = 0, 0, Me.txtFee / Me.txtActualHours)<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


It looks like the syntax may be off on your statement, you may want this (not worrying about data types for a minute...).

Me.txtDollarsPerHour = IIf(Me.txtActualHours = 0, 0, Me.txtFee / Me.txtActualHours)



----------------------------------------

»bp

Yes.  It is zero.  How do I fix the code?

<div>
See above, I updated my comment...<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


See above, I updated my comment...



----------------------------------------

»bp

<div>
Still getting overflow. &nbsp;Both txtActualHours and txtFee are zero.
</div>


Still getting overflow.  Both txtActualHours and txtFee are zero.

<div>
txtFee is currency. &nbsp;txtActualHours is Number, single, standard, 2. &nbsp; txtDollarsPerHour is currency.
</div>


txtFee is currency.  txtActualHours is Number, single, standard, 2.   txtDollarsPerHour is currency.

<div>
This worked:<br />
<br />
If txtActualHours = &quot;0&quot; Then<br />
&nbsp; &nbsp; txtDollarsPerHour = &quot;0&quot;<br />
Else<br />
&nbsp; &nbsp; txtDollarsPerHour = txtFee / txtActualHours<br />
End If<br />
<br />
Thanks!
</div>


This worked:

If txtActualHours = "0" Then
    txtDollarsPerHour = "0"
Else
    txtDollarsPerHour = txtFee / txtActualHours
End If

Thanks!

<div>
Welcome, glad that helped.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


Welcome, glad that helped.



----------------------------------------

»bp

<div>
<div class="content wysiwyg-content">
I'm getting an overflow error when a form opens. &nbsp;The code gets stuck on:<br />
<br />
Me.txtDollarsPerHour = IIf(Me.txtActualHours = 0, 0, Me.txtDollarsPerHour = Me.txtFee / Me.txtActualHours)<br />
<br />
Note: &nbsp;If I put a breakpoint on the line then Me.DollarsPerHour is null. &nbsp;Maybe that has something to do with it?
</div>
</div>


I'm getting an overflow error when a form opens.  The code gets stuck on:

Me.txtDollarsPerHour = IIf(Me.txtActualHours = 0, 0, Me.txtDollarsPerHour = Me.txtFee / Me.txtActualHours)

Note:  If I put a breakpoint on the line then Me.DollarsPerHour is null.  Maybe that has something to do with it?

Why getting an overflow error when tryint to open a form

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.