By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,991 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,991 IT Pros & Developers. It's quick & easy.

List box display with conditional formating

P: 6
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.
May 9 '07 #1
Share this Question
Share on Google+
1 Reply


ADezii
Expert 5K+
P: 8,619
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.
  1. You can ORDER BY the [contacts] Field and set its Column Width to 0 to accomplish this part of what you are requesting.
  2. As far as the color part, no can do!
May 9 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.