[AccessD] Conditional formatting on combo box

Thanks.

Carolyn

  ----- Original Message ----- 
  From: David McAfee 
  To: Access Developers discussion and problem solving 
  Sent: Friday, September 17, 2010 5:12 PM
  Subject: Re: [AccessD] Conditional formatting on combo box


  Here's the link for his sample, if you want to have a look:

  http://www.rogersaccesslibrary.com/forum/at-your-survey_topic3.html



  On Fri, Sep 17, 2010 at 3:09 PM, Carolyn Johnson <cjlabs at att.net> wrote:
  > I was hoping to avoid adding Enrolled or Not enrolled as a visible column and just go with formatting, but showing the column serves the purpose.
  >
  >
  > Thanks
  > Carolyn
  >
  > ----- Original Message -----
  > From: Charlotte Foust
  > To: Access Developers discussion and problem solving
  > Sent: Friday, September 17, 2010 5:03 PM
  > Subject: Re: [AccessD] Conditional formatting on combo box
  >
  >
  > Sorry, but that isn't possible with the built in combo box. The
  > built-in combo box is populated by a string, with a delimiter to
  > indicate line breaks. No way to format anything but the entire
  > control. I wouldn't recommend different formats in rows anyhow. You
  > could, of course, make the ENROLLED all caps to distinguish form Not
  > Entrolled, which would serve the same purpose..
  >
  > Charlotte Foust
  >
  > On Fri, Sep 17, 2010 at 1:38 PM, Carolyn Johnson <cjlabs at att.net> wrote:
  > > Is it possible to use conditional formatting to change the appearance of rows in a combo box? Not the value of the combo box, but the appearnace of values in the rowsource?
  > >
  > > I'd like to make certain values bold and others normal based on a column's value (not the bound column) in the rowsource as an aid in selecting the correct row (ie, enrolled vs not enrolled).
  > >
  > >
  > > Thanks
  > > Carolyn Johnson
  > > --
  > > AccessD mailing list
  > > AccessD at databaseadvisors.com
  > > http://databaseadvisors.com/mailman/listinfo/accessd
  > > Website: http://www.databaseadvisors.com
  > >
  >
  > --
  > AccessD mailing list
  > AccessD at databaseadvisors.com
  > http://databaseadvisors.com/mailman/listinfo/accessd
  > Website: http://www.databaseadvisors.com
  > --
  > AccessD mailing list
  > AccessD at databaseadvisors.com
  > http://databaseadvisors.com/mailman/listinfo/accessd
  > Website: http://www.databaseadvisors.com
  >

  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com