<div>
Does this work?<br />
<br />

<pre><code id="code-20-41849458-1">=Format((Val(Nz([txtPosCnt]))/Val(Nz([txtPosCnt]))+Val(Nz([txtNegCnt])))/100,&quot;#%&quot;)</code></pre>
</div>


Does this work?



=Format((Val(Nz([txtPosCnt]))/Val(Nz([txtPosCnt]))+Val(Nz([txtNegCnt])))/100,"#%")

<div>
Joe,<br />
<br />
This works if txtNegCnt is blank but errors if txtPosCnt is blank as well. Can you assist with check if both fields are blank?
</div>


Joe,

This works if txtNegCnt is blank but errors if txtPosCnt is blank as well. Can you assist with check if both fields are blank?

<div>
Nevermind! Figured it out! Thanks again!
</div>


<div>
Cool. &nbsp;Mainly, you have to prevent Divide By Zero ....and ... Null propagation - hence the Nz() to convert Null to Zero.<br />
<br />
Sorry ... I went to bed shortly after that post.
</div>


Cool.  Mainly, you have to prevent Divide By Zero ....and ... Null propagation - hence the Nz() to convert Null to Zero.

Sorry ... I went to bed shortly after that post.

<div>
<div class="content wysiwyg-content">
Dear Experts,<br />
<br />
Wondering if you all could help me with this expression:<br />
The following expression is in the control source of txtPercentPos:<br />

<pre><code id="code-10-28977318-1">=Format((Val([txtPosCnt])/Val([txtPosCnt])+Val([txtNegCnt]))/100,&quot;#%&quot;)</code></pre>
<br />
but when I display the continuous form I get:<br />
<a href="https://filedb.experts-exchange.com/incoming/2016/10_w43/1122948/screenshot.png" target="_blank" title="screenshot (12 KB)"><img alt="screenshot" class="file-block lazyload" style="max-width: 402px;" data-src="https://filedb.experts-exchange.com/incoming/2016/10_w43/1122948/screenshot.png" /></a><br />
How can I prevent the error from happening if there are no values in the txtPosCnt or txtNegCnt textboxes?<br />
<br />
Thanks!
</div>
</div>


screenshot.png

Dear Experts,

Wondering if you all could help me with this expression:
The following expression is in the control source of txtPercentPos:
(CODE)

but when I display the continuous form I get:


How can I prevent the error from happening if there are no values in the txtPosCnt or txtNegCnt textboxes?

Thanks!

Getting #Type! error in expression builder

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.

Microsoft Access

Visual Basic for Applications (VBA) enables building user-defined functions (UDFs), automating processes and accessing Windows API and other low-level functionality through dynamic-link libraries (DLLs). VBA is closely related to Visual Basic and uses the Visual Basic Runtime Library, but it can normally only run code within a host application rather than as a standalone program. It can, however, be used to control one application from another via OLE Automation. VBA is built into most Microsoft Office applications.