473,387 Members | 1,486 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,387 software developers and data experts.

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

176 100+
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
4 2666
NeoPa
32,556 Expert Mod 16PB
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
Michael R
176 100+
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
32,556 Expert Mod 16PB
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
14,534 Expert Mod 8TB
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

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

Similar topics

3
by: Jouke Langhout | last post by:
Hello all! For quite some time now, I've got the following problem: Access won't close properly when a user closes the application. An ACCESS process stays active and that process can only be...
2
by: Terry | last post by:
I have a form which displays data from both the Student Details table and the Exam Details table. The Name (Text Box) control is from the Student Details table and the Withdrawn (Check Box)...
2
by: jeffgeorge | last post by:
Trying to add 3 colors to 6 combinations of text possibilities. If this makes sense, the possibilities are: A D (one color for the combo beginning with A) A E B D (One color for the combo...
4
by: Bradley | last post by:
I have an A2000 database in which I have a continuous form with a tick box. There is also a text box with a conditional format that is based on the expression , if it's true then change the...
2
by: Megan | last post by:
Can you write conditional VBA code that affects only one or two records on a continuous subform? I have a form with a subform on it. The parent/ child field that links the forms is CaseID. The...
2
by: Von Bailey | last post by:
I have a form where the conditional formatting is set on some fields to bold if certain conditions are met. However, when the conditions are met some of the data that is to bold is either not...
1
by: GGerard | last post by:
Hello Is there a way to use a variable in the Conditional Formatting of a Textbox? Example : I want the background of a textbox in a continuous form to change color when the value of...
8
by: Typehigh | last post by:
I have many text fields with conditional formatting applied, specifically when the condition is "Field Has Focus". Without any events associated with the fields the conditional formatting works...
4
by: festerian | last post by:
Hi everybody - I'm a new access user and would appreciate some help. I'm trying to create a form, on which I'm trying to disable/enable a combo box, based on the value entered in another combo box...
6
by: BUmed | last post by:
Hi all I’m trying to figure this out. But help is needed. I have a combo box called fcmFLAG with 5 options (problem, hold off, call, withdrew and ineligible). What I would like to do is have the...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.