By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,952 Members | 1,722 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,952 IT Pros & Developers. It's quick & easy.

Format Condition Confusion

P: n/a
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.
Aug 8 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Aug 8 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.