Can you count conditionally colored fields?

[jjsande1492]

Hi, everyone.

I have a datasheet subform with many fields being displayed (upwards of 100). Some of these are conditionally formatted so if they're blank, they're colored in red. The idea being that users are being reminded that they have to populate all of the required data. The number of 'red' (mandatory) fields will vary. For example, if one field is populated a certain way, two others then become red as well. I want to know how many 'red' cells there are by record. Is there a way to count these cells? My experience in Excel VBA says no, but I thought I would ask. I'd be open to alternative methods to accomplish my goals.



Cheers,
jj

[ranman256]

if its a format condition, then its a data condition too.
use a query to count the recs. (or DCount)

[June7]

If you want to count how many fields of a single record are Null, something like:
IIf(IsNull(field1), 1, 0) + IIf(IsNull(field2), 1, 0) + IIf(IsNull(field3), 1, 0)

As you can see, 100 fields will be impractical. I expect you will have to write a custom function.

Of what use is this count?

100 fields is really quite a lot. Possibly data structure could be more normalized.

[jjsande1492]

Thanks for the responses. The purpose of the count is to determine how many fields are required and how many are left to be filled in. I was trying to avoid counting the number of null fields of a record because that will become complicated. It would be much simpler to count the number of 'red' cells. It doesn't sound like that is possible though. 100 fields is definitely a lot. I have some other posts on this board where I've been interrogated on my normalization. I have improved the structure and joined everything together to give the user a single form with everything on it which is what is required.

Thanks again.