Prev: emailing a large database - any extreme zip program out there?
Next: Lookupform(s)
From: Terrence Carroll on 21 Apr 2010 10:15
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?
From: Gina Whipp on 21 Apr 2010 10:40
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

"Terrence Carroll" <TerrenceCarroll(a)discussions.microsoft.com> wrote in
message news:63C0617F-6F47-41B9-8034-E0F7F81C01B6(a)microsoft.com...
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?

From: Tom van Stiphout on 21 Apr 2010 10:47
On Wed, 21 Apr 2010 07:15:01 -0700, Terrence Carroll
<TerrenceCarroll(a)discussions.microsoft.com> wrote:

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


>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?
 | 
Pages: 1
Prev: emailing a large database - any extreme zip program out there?
Next: Lookupform(s)