[AccessD] Conditional formatting on combo box

I'm sorry. That was the wrong sample.

You want the top one on this link

http://www.access.hookom.net/Samples.htm



On Fri, Sep 17, 2010 at 3:15 PM, Carolyn Johnson <cjlabs at att.net> wrote:
> Thanks.
>
> Carolyn
>
>  ----- Original Message -----
>  From: David McAfee
>  To: Access Developers discussion and problem solving
>  Sent: Friday, September 17, 2010 5:12 PM
>  Subject: Re: [AccessD] Conditional formatting on combo box
>
>
>  Here's the link for his sample, if you want to have a look:
>
>  http://www.rogersaccesslibrary.com/forum/at-your-survey_topic3.html
>
>
>
>  On Fri, Sep 17, 2010 at 3:09 PM, Carolyn Johnson <cjlabs at att.net> wrote:
>  > I was hoping to avoid adding Enrolled or Not enrolled as a visible column and just go with formatting, but showing the column serves the purpose.
>  >
>  >
>  > Thanks
>  > Carolyn
>  >
>  > ----- Original Message -----
>  > From: Charlotte Foust
>  > To: Access Developers discussion and problem solving
>  > Sent: Friday, September 17, 2010 5:03 PM
>  > Subject: Re: [AccessD] Conditional formatting on combo box
>  >
>  >
>  > Sorry, but that isn't possible with the built in combo box. The
>  > built-in combo box is populated by a string, with a delimiter to
>  > indicate line breaks. No way to format anything but the entire
>  > control. I wouldn't recommend different formats in rows anyhow. You
>  > could, of course, make the ENROLLED all caps to distinguish form Not
>  > Entrolled, which would serve the same purpose..
>  >
>  > Charlotte Foust
>  >
>  > On Fri, Sep 17, 2010 at 1:38 PM, Carolyn Johnson <cjlabs at att.net> wrote:
>  > > Is it possible to use conditional formatting to change the appearance of rows in a combo box? Not the value of the combo box, but the appearnace of values in the rowsource?
>  > >
>  > > I'd like to make certain values bold and others normal based on a column's value (not the bound column) in the rowsource as an aid in selecting the correct row (ie, enrolled vs not enrolled).
>  > >
>  > >
>  > > Thanks
>  > > Carolyn Johnson
>  > > --
>  > > 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
>  >
>
>  --
>  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
>