[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
>