Conditional Format - Sometimes works, sometimes not

  • Thread starter Thread starter Martin Schneider
  • Start date Start date
M

Martin Schneider

Hi!

I have a form with a pretty complex query being the data source for a
field. Depending on the field's value, another field is being
conditionally formatted with colours red, yellow, green.

The problem is: The complexity of the query seems to be a problem to Access.

First of all, colorizing the table takes quite some time (in terms of
seconds), even on fast machines.
Second, in my opinion depending on CPU load and concurrent user
interaction, some rows don't get any color at all.
On some machines, the conditional formatting doesn't work at all - all
fields stay white.

Is this a known problem to Access 2000? Can anybody help me with a clue
how to solve this?

Thank you for your ideas.

Best regards,
Martin
 
Allen said:
Conditional Formatting is demanding, and there are some bugs in its
implementation. Microsoft has fixed some of these, so the first thing you
will want to do is ensure you have SP3 for Office 2000, and at least SP8 for
JET 4.
Click to expand...

Thanks for the hint! I just wrote a mail to the customer's IT support
and will report whether the problem was solved.

Best regards,
Martin
 
Back
Top