First, you can't bind labels to data, so I'm not sure what you mean by that. You can link/attach them to controls though. For reports and continuous forms, if any record in a field/control does not meet the condition you specify, the effect is not applied to any of the controls in that field. Acc3 exists in each record whether or not it has data, and Access does not distinguish between the first row and the nth row. In your case, as long as even one is not Null, basically it (all of them) are all not Null. Note: I am not saying that conditional formatting cannot cause some to be colored differently than others. That is a different situation.
Last edited by Micron; 05-02-2016 at 03:07 PM.
Reason: grammar
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.