[AccessD] Conditional formatting on combo box

Carolyn Johnson cjlabs at att.net
Sat Sep 18 07:26:36 CDT 2010


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


More information about the AccessD mailing list