Format Condition Confusion

[Randy Harris]

I thought that Access 2000 supported more than one FormatCondition for a
control. I have two:

Me(CCtl).FormatConditions(0).BackColor = lngTravel
Me(CCtl).FormatConditions(1).ForeColor = RGB(0, 0, 255)

If either condition is true, the appropriate Format is applied to the
control. If both, however, are met, it only applies the first
condition. (Whichever one is first, the BackColor as shown).

Am I wrong thinking that it should support both? Any suggestion is
appreciated.
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.

[Allen Browne]

Randy, my recollection matches your experience, i.e. Access treats the
FormatConditions like a Select Case statement, and only the first match is
processed.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Randy Harris" <pl****@send.no.spamwrote in message
news:3d****************@newssvr27.news.prodigy.net ...

>I thought that Access 2000 supported more than one FormatCondition for a
control. I have two:

Me(CCtl).FormatConditions(0).BackColor = lngTravel
Me(CCtl).FormatConditions(1).ForeColor = RGB(0, 0, 255)

If either condition is true, the appropriate Format is applied to the
control. If both, however, are met, it only applies the first condition.
(Whichever one is first, the BackColor as shown).

Am I wrong thinking that it should support both? Any suggestion is
appreciated.
--
Randy Harris
tech at promail dot com
I'm pretty sure I know everything that I can remember.