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 <stormovick (ditch) @hotmail.com> wrote:

>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.


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
MVP [MS Access]

Marsh,

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

Vanya

"Marshall Barton" wrote:

> Ivan Grozney <stormovick (ditch) @hotmail.com> wrote:
>
> >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.
>
>
> 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
> MVP [MS Access]
>

Ivan Grozney <stormovick (ditch) @hotmail.com> wrote:

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


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

--
Marsh
MVP [MS Access]