Contents of Form Fields not Displaying

[rdc2732]

I have a form with 10 numeric input fields (envision two rows and five
columns). There is a column at the right for a total of each of the
fields on each row. There is also a row with a calculation based on
the two input fields in each column.

When a record is retrieved, the calculated fields should automatically
display the results based on the values in each field. For several of
the calculated fields, this works perfectly. However, for some of
them, they are blank. But, if I put my cursor in the blank fields, the
data is displayed.

It seems to be some kind of screen refresh problem, but the behavior is
very consistent.

[Allen Browne]

Use Nz() to tell Access to use a zero for null.

The Control Source of the calculated text box will be something like this:
=Nz([Field1],0) + Nz([Field2],0) + ...

More info:
Common errors with Null
at:
http://allenbrowne.com/casu-12.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<rd*****@earthl ink.net> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

I have a form with 10 numeric input fields (envision two rows and five
columns). There is a column at the right for a total of each of the
fields on each row. There is also a row with a calculation based on
the two input fields in each column.

When a record is retrieved, the calculated fields should automatically
display the results based on the values in each field. For several of
the calculated fields, this works perfectly. However, for some of
them, they are blank. But, if I put my cursor in the blank fields, the
data is displayed.

It seems to be some kind of screen refresh problem, but the behavior is
very consistent.

[rdc2732]

Hi Allen, I think the Nz cleaned up some other stuff, but I am still
having a strange problem. The form works correctly pulling fields from
the database. However, some of the lookup fields and some of the
calculated fields work correctly. The others do not show the data
unless I mouse click or tab into the blank cells. At that point, the
data is displayed. The values may either be zero, nonzero or nulls
(now fixed by nz to return be a zero).

Thanks in advance,
Rick Cottle

[Allen Browne]

That could be a range of things, Rick. e.g.:

- Video driver: screen is not updating the values.

- Timing issue: Access is not recalculating at the time you need.

- Dependency: Something has to get done (saved?) in order for the calculated
totals to reflect correctly.

- Bug in Access: There is a timing issue with the display of combos set in
Form_Current where the bound column is zero-width, as described in the 2nd
part of this article:
http://allenbrowne.com/bug-06.html

- Issues interpreting the data type:
http://allenbrowne.com/ser-45.html

And so on.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<rd*****@earthl ink.net> wrote in message
news:11******** **************@ g14g2000cwa.goo glegroups.com.. .

Hi Allen, I think the Nz cleaned up some other stuff, but I am still
having a strange problem. The form works correctly pulling fields from
the database. However, some of the lookup fields and some of the
calculated fields work correctly. The others do not show the data
unless I mouse click or tab into the blank cells. At that point, the
data is displayed. The values may either be zero, nonzero or nulls
(now fixed by nz to return be a zero).

Thanks in advance,
Rick Cottle