Conditional Formatting Running Slowly

[M_S_Jones]

Hi,

Can anyone provide any tips for making conditional formatting a bit faster to load? I have a continuous subform with several objects subject to conditional formatting, including a long unbound textbox the length of the row. When I scroll in the subform I find that it takes a couple of seconds sometimes to render the colour changes, particularly with the long text box. I'm using Access 2010 and most of the conditions are simple expressions based on the value of one other field. Any help anyone can offer would be appreciated.

Thanks,

Matthew

 

[Shipper225]

From my experience with the conditional formatting in Access 2010 is that if you use it in a form and you move to the next line it basically reloads everything each time. I only use the conditional formatting in reports as it tends to keep things moving at a decent pace.

 

[missinglinq]

Conditional Formatting has always been a bit snail-like, at times, and a lot of things tend to run slower in 2007/2010, so I think you're merely seeing the result of these two things coming together.

The fact that "most of the conditions are simple expressions based on the value of one other field" is probably off-set by the fact that there are multiple Fields in each Record set up like this.

And, of course, if you're talking about the speed of processing something, the inherit characteristics of the PC you're running it on, as well as any other processing being done, could also slow things down.

Linq ;0)>