|
From: Billiam on 3 Jul 2008 16:00 It does not appear to me that Stephen Lebans has done this...oh well! "Jeff Boyce" wrote: > I am not aware of a way within Access, but you might want to visit Stephen > Lebans' website to see if he's done something like this... > > http://www.lebans.com/ > > Regards > > Jeff Boyce > Microsoft Office/Access MVP > > "Billiam" <Billiam(a)discussions.microsoft.com> wrote in message > news:1A24D224-312C-41FA-9B19-863D393B4AAF(a)microsoft.com... > >I have a bound drop down list box which displays 7 set choices: Active, > > Interim, On Leave, suspended, de-certifed, resigned and deceased. I would > > like to add colour to some of the choices, so the items are noticed more > > easily (ie the colour red is the background to the choice Suspended, the > > colour green is the background to the choice Active). > > Can this be done within the same drop down list box? > > Billiam > > >
From: strive4peace on 3 Jul 2008 21:55
How about using a subform with conditional formatting? Warm Regards, Crystal remote programming and training Access Basics 8-part free tutorial that covers essentials in Access http://www.AccessMVP.com/strive4peace * (: have an awesome day :) * Billiam wrote: > I have a bound drop down list box which displays 7 set choices: Active, > Interim, On Leave, suspended, de-certifed, resigned and deceased. I would > like to add colour to some of the choices, so the items are noticed more > easily (ie the colour red is the background to the choice Suspended, the > colour green is the background to the choice Active). > Can this be done within the same drop down list box? > Billiam |