On 3 Mar 2007 13:59:40 -0800, "Ap******@gmail.com"
<Ap******@gmail.comwrote:
Re: 1: Too bad, so sad. But read Re: 2
Re: 2: Sure: you can create a single condition with "Expression Is",
and then as the expression you can specify your own function, which
would test all (more than 3) conditions you need. This must be a
public function in a standard module, returning a boolean.
AFAIK, there is no documented way to programmatically manipulate the
conditional formatting, but if you feel adventurous: open the object
browser (F2) right click Show hidden members then search for
"condi" (no, not Condi :-)) and you'll find interesting classes like
FormatCondition and FormatConditions to be explored.
-Tom.
>In a Continuous form, I want to use Conditional Formatting to change
the background color of a date field based on a condition.
1-The color chart in the CF menu option offers limited colors. How can
I use the custom colors I need ???
2-Is Conditional Formatting available in code, so that I can use more
than 3-conditions and have more versatility than the Access2k CF menu
option offers ???
Thanks Greg