Combo Box Value Change Color or ????

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a combo box where I change the rowsource based on information from the
form I am working with.

If the person has a medical plan they get certain benefits by doing things
to stay healthy. Their spouse can do so as well.

So if the employee is on the Med plan then certain things show up in their
drop down, different if they are not on the Med plan, and different yet if
the employee is on the Med plan and their spouse is as well.

Each person is allowed one physical per year. Other things twice a year, etc.

Okay, what the end user wants is a way to display all the items they are
"allowed" but if they had their physical, then have it grayed out or in red
or ??? in the drop down of the combo box. I can not display the item but as
for displaying it another way, I have played with it but have had no luck.

tia

Vanya
 
Ivan Grozney said:
I have a combo box where I change the rowsource based on information from the
form I am working with.

If the person has a medical plan they get certain benefits by doing things
to stay healthy. Their spouse can do so as well.

So if the employee is on the Med plan then certain things show up in their
drop down, different if they are not on the Med plan, and different yet if
the employee is on the Med plan and their spouse is as well.

Each person is allowed one physical per year. Other things twice a year, etc.

Okay, what the end user wants is a way to display all the items they are
"allowed" but if they had their physical, then have it grayed out or in red
or ??? in the drop down of the combo box. I can not display the item but as
for displaying it another way, I have played with it but have had no luck.
Click to expand...


Sorry, but there is no Access capability to affect the
colors in a combo box list.

If this is really important, you could use a continuous
subform and a text box to simulate a combo box, but it will
take a significant amount of fairly tricky code. Of course
this kind of thing can not be used in a datasheet or
continuous form.
 
Marsh,

Thanks! I didn't think so and it sounds like it would be ton of brain
damage for little gain.

Vanya
 
Ivan Grozney said:
Marsh,

Thanks! I didn't think so and it sounds like it would be ton of brain
damage for little gain.

Vanya
Click to expand...


Excellent summary of the situation (unless Stephen Lebans
decides it's an interesting challenge ;-)
 
Back
Top