I have a continuous form that uses conditional formatting.
It also logs activity in a table (like this identity is inactive). In order to keep the row source updatable, it uses a function to retrieve the current active status in the record source SQL.
To make things more interesting, on current there is a combo box that has its row source set according to a value in another record. This combo box displays the value stored and not one of the other columns.
If I have a conditional formatting rule to turn the text of the box red, every record change it is obviously setting all controls to not have formatting and then applying the conditional formats. This takes about half a second by my estimation. It is long enough to spot black values and watch the screen apply the red text.
Any thoughts on suppressing the format re-drawing until it is done? I tried both docmd.echo and Me.Painting on current and that did not help.
This is a minor annoyance and for now I decided to definitely not use red text but there is still some noticeable flicker since there are controls with enabled toggled by formatting as well. I suspect this conditional formatting timing issue is not within our control, but I figure it can't hurt to ask.
It also logs activity in a table (like this identity is inactive). In order to keep the row source updatable, it uses a function to retrieve the current active status in the record source SQL.
To make things more interesting, on current there is a combo box that has its row source set according to a value in another record. This combo box displays the value stored and not one of the other columns.
If I have a conditional formatting rule to turn the text of the box red, every record change it is obviously setting all controls to not have formatting and then applying the conditional formats. This takes about half a second by my estimation. It is long enough to spot black values and watch the screen apply the red text.
Any thoughts on suppressing the format re-drawing until it is done? I tried both docmd.echo and Me.Painting on current and that did not help.
This is a minor annoyance and for now I decided to definitely not use red text but there is still some noticeable flicker since there are controls with enabled toggled by formatting as well. I suspect this conditional formatting timing issue is not within our control, but I figure it can't hurt to ask.
