[AccessD] Conditional formatting on combo box

Carolyn Johnson cjlabs at att.net
Fri Sep 17 17:09:00 CDT 2010


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


More information about the AccessD mailing list