[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:23 PM
  Subject: Re: [AccessD] Conditional formatting on combo box


  I'm sorry. That was the wrong sample.

  You want the top one on this link

  http://www.access.hookom.net/Samples.htm



  On Fri, Sep 17, 2010 at 3:15 PM, Carolyn Johnson <cjlabs at att.net> wrote:
  > 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
  > --
  > 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