[AccessD] Conditional formatting on combo box

Another good idea -- a way to use formatting instead of adding a column.

Thanks
Carolyn

  ----- Original Message ----- 
  From: Stuart McLachlan 
  To: Access Developers discussion and problem solving 
  Sent: Saturday, September 18, 2010 8:24 AM
  Subject: Re: [AccessD] Conditional formatting on combo box


  If ou want to keep the entries in alphabetical order, you can do something like
  iif(IsEnrolled,UCase([Name]),[Name])

  -- 
  Stuart

  On 18 Sep 2010 at 7:26, Carolyn Johnson wrote:

  > That's what I've gone with as well -- as asterisk.
  > 
  > Thanks
  > Carolyn
  >   ----- Original Message ----- 
  >   From: Doug Steele 
  >   To: Access Developers discussion and problem solving 
  >   Sent: Saturday, September 18, 2010 12:51 AM
  >   Subject: Re: [AccessD] Conditional formatting on combo box
  > 
  > 
  >   What I have done in a similar situation is to either set the value
  >   of the Name dropdown column to some visible formatting, like:
  > 
  >   =Name & iif(IsEnrolled," **","")
  > 
  >   or to add a sort by IsEnrolled as well so that all the names that
  >   aren't enrolled show after the names that are enrolled.
  > 
  >   Doug Steele
  >   -- 
  >   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