[AccessD] Conditional formatting on combo box

David McAfee davidmcafee at gmail.com
Fri Sep 17 17:12:50 CDT 2010


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
>




More information about the AccessD mailing list