Conditional Formatting - Database performance

[Terrence Carroll]

In general I was wondering if conditional formatting has any detrimental
impact on database performance. Is this something I should use to highlight
particular exceptions or data that falls outside the bounds of a certain
range or is there something else that will work better?

 

[Gina Whipp]

Terrence,

Use Conditional Formatting quite frequently and have never noticed any slow
down. The only issue has ever been been if you want more than three
conditions then you'll have to use VBA to *simulate* the built in
functionality.

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

message In general I was wondering if conditional formatting has any detrimental
impact on database performance. Is this something I should use to highlight
particular exceptions or data that falls outside the bounds of a certain
range or is there something else that will work better?

 

[Tom van Stiphout]

On Wed, 21 Apr 2010 07:15:01 -0700, Terrence Carroll

I have noticed that on a complex form the conditional formatting comes
in a second or so later. So it seems to be running on a separate
thread and should not affect overall performance too much.

-Tom.
Microsoft Access MVP