List box display with conditional formating

OxfordConsult

I have a form in which a selection in a list box pulls a record to be displayed in a subform.

All contacts are categorised as either Active, Inactive, or left company. I was wondering if it is possible to have these contacts ordered in my list box by this status (although not displayed in the list box) and coloured accordingly. (red for inactive, blue for left company, black for active). The list box gets its information from a query based on the prior list boxes that a user has to choose.

Any help would be greatly appreciated.

ADezii

Quote:

Originally Posted by OxfordConsult

I have a form in which a selection in a list box pulls a record to be displayed in a subform.

All contacts are categorised as either Active, Inactive, or left company. I was wondering if it is possible to have these contacts ordered in my list box by this status (although not displayed in the list box) and coloured accordingly. (red for inactive, blue for left company, black for active). The list box gets its information from a query based on the prior list boxes that a user has to choose.

Any help would be greatly appreciated.

You can ORDER BY the [contacts] Field and set its Column Width to 0 to accomplish this part of what you are requesting.
As far as the color part, no can do!

List box display with conditional formating

re: List box display with conditional formating

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about