<div>
Incidentally, the field that is acting strange has this code:<br />
<br />
Difference: (Nz([field1],0)+Nz([field2<wbr />],0)+Nz([f<wbr />ield3],0)+<wbr />Nz([field4<wbr />],0)+Nz([f<wbr />ield5],0)+<wbr />Nz([field6<wbr />],0))-[fie<wbr />ld7]
</div>


<div>
Try changing it to:<br />
<br />
Difference: (Nz([field1],0)+Nz([field2<wbr />],0)+Nz([f<wbr />ield3],0)+<wbr />Nz([field4<wbr />],0)+Nz([f<wbr />ield5],0)+<wbr />Nz([field6<wbr />],0))-NZ([<wbr />field7], 0)<br />
<br />
added an NZ( ) function around [Field7]
</div>


<div>
Same problem. &nbsp; One field in the form that only displays values when the scroll bar is clicked. &nbsp;When it is not clicked the values disappear.
</div>


<div>
Have you checked to make sure that fields foreground and background color are not the same?
</div>


<div>
They are not the same. &nbsp;Backcolor is white. &nbsp;Forecolor is black.
</div>


<div>
Do you have a program like &quot;SnagIt&quot; or &quot;Camtasia&quot; which will allow you to record screen video?<br />
<br />
If so, use that to record the situation you are encountering, then post it back here.
</div>


<div>
You could also post a sample database (just the relevant forms and tables, and any sensitive data removed).<br />
<br />
Do the field1, field2, etc names refer to Textboxes/Other controls on your form, or do they refer to the underlying fields in your query or table? &nbsp;(If textboxes/other controls, change it so that they reference the actual fields in the recordsource table or query)
</div>


<div>
Also - a general debugging tip... Break the problem down.<br />
<br />
Start with a simpler expression to see if any part of it works as expected, and then add to it until you find the breaking point.<br />
<br />
ie: Start with this:<br />

<pre><code class="code-1 nolinks" id="code-20-42710356-1"><span>Nz([field1],0)</span>
</code></pre>
If that works, try:<br />

<pre><code class="code-1 nolinks" id="code-20-42710356-2"><span>Nz([field1],0)+Nz([field2],0)</span>
</code></pre>
Then:<br />

<pre><code class="code-1 nolinks" id="code-20-42710356-3"><span>Nz([field1],0)+Nz([field2],0)+Nz([field3],0)</span>
</code></pre>
etc...
</div>


<div>
MBizup: &nbsp;I tried your suggestion and everything worked until I added the last field, -NZ([field7], 0). &nbsp;Strange. &nbsp;So then I tried something different. &nbsp;Instead of using the linked Excel file, I created a make table query to use the Excel file and then used the table for the form instead of the linked Excel file. &nbsp;IT WORKED! &nbsp;What in the world?
</div>


<div>
See if the field7 part works on its own without the other fields.<br />
It’s possible that reading from the Excel spreadsheet might be bogging things down to the extent that you’re seeing the strange behavior you’re describing. &nbsp;Using a table would be a good bit more efficient.
</div>


<div>
It does work by itself. &nbsp;Is a mystery.
</div>


<div>
Try removing the NZ functions in your expression, and just use the field names. &nbsp;Do you actually have blanks in these fields? &nbsp;I believe blanks in Excel are empty strings, not nulls (which is what the NZ function affects).<br />
<br />
And as a side note, I generally do not use spreadsheets directly in queries, reports or forms. &nbsp;Instead, I import the raw data into a staging table temporarily, and then format it as needed, moving it into into a permanent table, which is what I then use for queries, forms and reports.
</div>


Owner, Dev-Soln LLC

Dale Fye

SteveL13

<div>
As Miriam mentioned, if you are dealing with linked Excel spreadsheets, you cannot be certain that a cell value is NULL when it appears to be. &nbsp;It could be a zero length string, or even a string of spaces.<br />
<br />
I have a function which I use for purposes like this which allows me to sum across rows (used when I receive non-normalized data)<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-42711823-1"><span>Public Function fnSum(ParamArray ArrayOfValues() As Variant) As Variant</span>
<span></span>
<span>    Dim varSum As Variant</span>
<span>    Dim intLoop As Integer</span>
<span>          </span>
<span>    varSum = 0</span>
<span>    For intLoop = LBound(ArrayOfValues) To UBound(ArrayOfValues)</span>
<span>        If IsNull(ArrayOfValues(intLoop)) Then</span>
<span>            'do nothing</span>
<span>        ElseIf Trim(ArrayOfValues(intLoop) &amp; &quot;&quot;) = &quot;&quot; Then</span>
<span>            'do nothing</span>
<span>        ElseIf IsNumeric(ArrayOfValues(intLoop)) = False Then</span>
<span>            'do nothing</span>
<span>        Else</span>
<span>            varSum = varSum + Val(ArrayOfValues(intLoop))</span>
<span>        End If</span>
<span>    Next</span>
<span>    fnSum = varSum</span>
<span>          </span>
<span>End Function</span>
</code></pre>
</div>


<div>
Thank you Dale. &nbsp;I will hang on to that code.
</div>


<div>
<div class="content wysiwyg-content">
I have a continuous form that has a field that is acting strange. &nbsp;There is one field in the form that only displays values when the scroll bar is clicked. &nbsp;When it is not clicked the values disappear.<br />
<br />
What would be causing this? &nbsp;I have no formatting going on anywhere.
</div>
</div>


I have a continuous form that has a field that is acting strange.  There is one field in the form that only displays values when the scroll bar is clicked.  When it is not clicked the values disappear.

What would be causing this?  I have no formatting going on anywhere.

Strange form field bevavior

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.