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