MS Access 97 Conditional Formatting
Posted on 2004-11-29
MS Access 97 does not support conditional formatting feature, so I tried making my own for reports.
The onLoad event does not help as the fields are not populated at that time. But onActivate function solves the problem. e.g. I can change the backColor or a txtBox based on its value using this event. Works fine!!
But prob arises in the following case: Parent Report A has a section subReport B. in the onActivate function of B I have conditional formatting code. If I open A (which indirectly opens B within itself) the onActivate function is not called. Hence not performing the conditional formatting.
Is there an alternative to this? i.e. Either calling onActivate function or using some other way to perform the same task?