Conditional formatting does not work for all cells

[dirkg]

Hi, I have a continuous form on which I use Conditional Formatting for several controls. However when I open or requery the form, not all the cels are properly formatted. For some controls only some rows are formatted properly, for other none of them is formatted as it should be. Then som of the controls become properly formatted once that I have selected them once...?????

Any ideas what the resaon for this is?


Greetz,

Dirk

 

[dirkg]

Ha, this is funny...when I wrote the first thread and returned back to my Access application all the cells were formatted correctly...therefore I thought it might be just a matter of time because of some code that is still running...but no, it's just when I switch to another application and then back to Access it works...this is not funny :s
I tried Me.Requery, Me.repaint, Me.recalc...nothing helps but switching to another application and then back. Any ideas to solve this?

Thanks a lot in advance!

Greetz,


Dirk