<div>
Ah, don't worry about this question... i fixed it by adding validation to the field:<br />
<br />
[Forms]![frmOBSDataEntry]!<wbr />[Text171]*<wbr />4=Fix([For<wbr />ms]![frmOB<wbr />SDataEntry<wbr />]![Text171<wbr />]*4)<br />
<br />
Question solved :P
</div>


Ah, don't worry about this question... i fixed it by adding validation to the field:

[Forms]![frmOBSDataEntry]![Text171]*4=Fix([Forms]![frmOBSDataEntry]![Text171]*4)

Question solved :P

<div>
ah, you've gone and put some input in... I'll award it to you anyway :)
</div>


ah, you've gone and put some input in... I'll award it to you anyway :)

<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
I'm creating a form with some basic maths on it, but it keeps causing overflow errors... i know a work around... but it means the form has to lose some functionality.<br />
<br />
There are 4 fields...<br />
<br />
Total(Text169), Actual(Text171), Special1(Text161), Special2(Text164)<br />
<br />
The following is used to create a string which is put into a label(Label166)... i.e.<br />
<br />
Label166.Caption = &quot;= &quot;&nbsp;&amp; (Text171 + Text161 + Text164) &amp;&nbsp;&quot; (&quot; &amp;&nbsp;Fix((Text171 + Text161 + Text164) / Text169 * 100) &amp;&nbsp;&quot;%)&quot;<br />
<br />
Now thats all well and good... here is the problem...<br />
<br />
1) When the form starts I want to populate all fields with &quot;0&quot; and set the label to &quot;= (NA%)&quot; which i have successfully done<br />
2) When a user updates any of the 4 fields I want the calculation to be run, except where total = 0 (as you can't divide by 0)<br />
3) When total = 0, Label = &quot;= [total] (NA%)&quot;<br />
<br />
Thanks for the help!!
</div>
</div>


Hello,

I'm creating a form with some basic maths on it, but it keeps causing overflow errors... i know a work around... but it means the form has to lose some functionality.

There are 4 fields...

Total(Text169), Actual(Text171), Special1(Text161), Special2(Text164)

The following is used to create a string which is put into a label(Label166)... i.e.

Label166.Caption = "= " & (Text171 + Text161 + Text164) & " (" & Fix((Text171 + Text161 + Text164) / Text169 * 100) & "%)"

Now thats all well and good... here is the problem...

1) When the form starts I want to populate all fields with "0" and set the label to "= (NA%)" which i have successfully done
2) When a user updates any of the 4 fields I want the calculation to be run, except where total = 0 (as you can't divide by 0)
3) When total = 0, Label = "= [total] (NA%)"

Thanks for the help!!

Help me overcome overflow 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.