Unlimited Conditional Formatting

[Lane Tharp]

We have a client that needs unlimited conditional
formatting in an Access Datasheet based on user selection.

Does anyone know of a way of removing the three condition
limitation or another stable solution.

We have seen a subclassing solution that is not stable. I
would rather use a third party or microsoft solution if
one exists.

PS: Any idea why there is a three condition limit. It
makes no sense to limit such globally useful
functionality.

 

[Stephen Lebans]

THe subclassing solution is stable if used correctly. The VB IDE window
can never be open at any time during the current session.

THere is no way around the 3 condition limit but you can have a function
of your own evaluated by CF so that you can simulate unlimited criteria
for each row. Again though, only three FormatCOnditions objects can
exist and you cannot modify this object at runtime.
Run time programmatic modification fo the FormatCOnditions object is
what really is needed to expand CF properly.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.