Subform Flickers On Open until first event.

[DFASWood]

I have a sub form that flickers when I open the master form. It stops
flickering when the mouse moves over the subform or clicks on the subform. I
am using conditional formatting on many textbox fields to change the color of
the record selected. The conditional format for each text box is as follows:

Condition 1:
Field Has Focus -> then I set the color and font.
Condition2:
Expression Is [Contract]=[txtCurKey1] And [INVOICE]=[txtCurKey2] And
[INV_AMT]=[txtcurKey3] -> then I set the color and font.
I'm thinking that perhaps I should use the format event on the subform to do
this formatting but I'm not sure about the code to use.

I've changed the Display properties under the control panel to Windows
classic because somewhere I read that would work but the flickering
continues.

Any help would be aprreciated.

 

[Allen Browne]

It is *very* easy to trigger this kind of endless looping with conditional
formatting, especially in Access 2000, and especially with calculated fields
or conditions that refer to calculated fields.

Access 2003 (at least from Sp1 onwards) fixes some of these issues, but
AFAIK, the only way to solve the problem is to remove the conditional
formatting that is triggering it.

Example of the problem:
http://allenbrowne.com/bug-05.html