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

FormatConditions: only 3?

P: n/a
After looking everywhere it appears that I can't get more than 3
format conditions in a FormatConditions collection. Stephan or
anyone: is this true? - tc

May 8 '07 #1
Share this Question
Share on Google+
4 Replies


P: n/a
On 8 May 2007 11:07:39 -0700, Tom Clavel <to*******@ouraynet.com>
wrote:

I seem to remember you can add more programmatically.
Even with 2 or 3, it can be pretty slow, with the color coming in well
after the form loads.

-Tom.

>After looking everywhere it appears that I can't get more than 3
format conditions in a FormatConditions collection. Stephan or
anyone: is this true? - tc
May 9 '07 #2

P: n/a
Three is the max. Technically it is 4 if you count the default.
What are you trying to do?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.
"Tom Clavel" <to*******@ouraynet.comwrote in message
news:11**********************@e51g2000hsg.googlegr oups.com...
After looking everywhere it appears that I can't get more than 3
format conditions in a FormatConditions collection. Stephan or
anyone: is this true? - tc

May 9 '07 #3

P: n/a
On May 8, 11:03 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@linvalid.comwrote:
Three is the max. Technically it is 4 if you count the default.
What are you trying to do?
I need to color-code municipalities in 12 or more colors. I am
considering using 3 or 4 conditional format fields, but I suspect it
will be slower than molasses. I will try linking to tiny images. This
feature may be mission-critical, so my last option is moving to a
different application. -tc

May 9 '07 #4

P: n/a
Tom Clavel wrote:
On May 8, 11:03 pm, "Stephen Lebans" <ForEmailGotoMy.WebSite.-
WWWdotlebansdot...@linvalid.comwrote:
>Three is the max. Technically it is 4 if you count the default.
What are you trying to do?

I need to color-code municipalities in 12 or more colors. I am
considering using 3 or 4 conditional format fields, but I suspect it
will be slower than molasses. I will try linking to tiny images. This
feature may be mission-critical, so my last option is moving to a
different application. -tc
Another option is to not use continuous forms and instead create an
unbound form that looks and behaves like a continuous form.

You would then have total control over how it behaves.

The drawback is that you need to write a considerable amount of code to
handle loading controls with data, performing record navigation, screen
paging and data addition, updates and deletes (assuming that is a
requirement of the app).

If you prefer to use Access and this is a mission-critical requirement
then give that idea some consideration.

-- John Mishefske UA Editor/MVP 2007
May 25 '07 #5

This discussion thread is closed

Replies have been disabled for this discussion.