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

A way or an ActiveX for Conditional Formatting on a Combo Box drop-down menu itself?

100+
P: 176
Does anyone know of such a way, or maybe have encountered an ActiveX control, that is able to have colors of conditional formatting on the drop-down list of a Combo box, besides the Combo box selected value?

It's a bit fanciful but can be convinient -

Thanks.
Dec 30 '06 #1
Share this Question
Share on Google+
4 Replies


NeoPa
Expert Mod 15k+
P: 31,276
Michael,

Would you mind rephrasing the question.
I tried to read it a couple of times but I couldn't get what you were after at all.
Try reading it through before you actually submit it and check that it makes sense to you.

MODERATOR.
Dec 31 '06 #2

100+
P: 176
Michael,

Would you mind rephrasing the question.
I tried to read it a couple of times but I couldn't get what you were after at all.
Try reading it through before you actually submit it and check that it makes sense to you.

MODERATOR.
Thanks for your remark.

What I ment to ask, was, whether anyone knows of any ActiveX control, or another method for to be able to have Conditional Formatting on the drop down list of a Combo Box. In other words: When a user opens a Combo Box, there's the drop down list. Is it possible to have conditioned colors on its rows/values?

Happy New Year!
Dec 31 '06 #3

NeoPa
Expert Mod 15k+
P: 31,276
OIC.
I'm afraid that I'm not aware of any way to do that :(.
I don't think it's possible. There's all sorts of things that can be done in code but I don't think this is one - sorry.
Dec 31 '06 #4

MMcCarthy
Expert Mod 10K+
P: 14,534
Thanks for your remark.

What I ment to ask, was, whether anyone knows of any ActiveX control, or another method for to be able to have Conditional Formatting on the drop down list of a Combo Box. In other words: When a user opens a Combo Box, there's the drop down list. Is it possible to have conditioned colors on its rows/values?

Happy New Year!
As far as I know 'Conditional Formatting' is one of those things that can't be coded easily. The only thing I've seen is extremely complicated code like this one on msdn.

Conditional Formatting in Access with VBA

Mary
Jan 1 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.