The Amazing Dissapearing Value

[monkeytunes]

Hello buddays,

I'm almost sure I've seen this problem addressed here before, but I wasn't able to locate a relevent thread.

I've got a calculated text box ("txtTotalScore") in the footer of a subform.

The subform contains a a tab box with three tabs. Each tab has another subform, with yet another calculated text box ("txtScore1", "txtScore2", "txtScore3")

The "txtTotalScore" calculated text box takes its value by summing these other score boxes. Everything works great...

...except when one of those sub-score boxes doesn't appear, due to no values appearing on the subform. The "txtTotalScore" will calculate with the relevent value for a moment, and then turn blank.

How do I account for the null/non-appearing text boxes?

Thanks in advance!

 

[Kraj]

The function (I believe) you need is HasData. Check out this post or do a search on that:

Rich is smart

 

[Rich]

The HasData method only works on Reports, use the Nz Function here
=Nz([field1])+Nz([Field2]) etc

 

[monkeytunes]

Kraj, Rich, thanks!

I'd read about the NZ function before, but didn't realize now was the time to use it. Shweet, budday, shweet. It's working like a charm.