Conditional formatting on Continuous Subform slow when using custom function.

Question

Hello all,

I've found a strange issue with conditional formatting. I have some code to assign conditional formats to a subform each time it opens (this allows for on the fly testing and ensures the latest rule is always applied to the expected controls). However, during my testing I found that simply calling a function in my conditional formatting slows the form down significantly. 

I have tested this with a simple =true vs a function that always returns true and the difference is about 3-5 seconds before the formatting is applied, but it is applied to all view-able lines at the same time...

Does anyone know why this is happening or how I might be able to speed this process up?

Answer 1

I can confirm what Tom says. I have had that exact experience.

Answer 2

I think it does not slow down the form, but only the application of CF which happens asynchronously.

The only way to speed it up is to use pre-computed data, so you don't have to compute on the fly.