Color Coding Data

[missymarie1014]

This is Access 2000. I have items residing in tables, some of which are labelled inactive through the use of a Boolean field. This causes the items not to appear in most forms and lookups, but there are some master edit forms and other forms where all items appear, active and inactive. What would be the best approach to having those items appear in a different color to designate their being inactive when viewed in a form or a combo box lookup? Thanks for any help!

 

[MajP]

In a form look at "conditional formatting". In a combobox I would show two columns with, one column with Active or Inactive. If you want color in a list like a combo you would have to use a list view control. This is not the easiest control to work with if you have never used one before. There is no way for color in a standard combo.