Graying out few items in access combo box

  • Thread starter Thread starter Jack
  • Start date Start date
J

Jack

Hi,
I have few items that need to be grayed out so that user cannot choose
those. Is there any way to do this in access. I appreciate any help. Thanks.
 
Hi,
I have few items that need to be grayed out so that user cannot choose
those. Is there any way to do this in access. I appreciate any help. Thanks.
Click to expand...

Not that I know of. Does the user need to SEE them, but be forbidden to use
them? Could the combo instead be based on a query showing only allowed values
(with perhaps some other control showing the full list)?
 
Thanks John. That is exactly what I need. Usesrs should see those but will be
forbidden to choose those
Any further thoughts
Thanks
 
Thanks John. That is exactly what I need. Usesrs should see those but will be
forbidden to choose those
Any further thoughts
Click to expand...

I can't think of any way to selectively grey out some rows of a combo. You
could use code in the combo's BeforeUpdate event to check to see if it's a
forbidden value and cancel the update, but that seems really user hostile!

How are the permitted and forbidden entries distinguished from one another? Is
there a field in the table that does so? You could display a string
concatenating the name you want to see with "OK To Pick" and "Don't Touch"
depending on that decision...
 
Thanks John. That is the method I have approached. This is something that
will work. However I wish Access had ways to gray out few of the items
in the combo box based on a criteria. However it seems Access has its
limitation.
Thanks
Regards
 
Back
Top