Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

Combo Box Colour Question

Discussion in 'Information Technology' started by Bob, Jul 28, 2006.

  1. Bob

    Bob
    Expand Collapse
    Guest

    I have a Combo Box that has 2 Options from Row Source (Active,Finished), How
    can I get the Font to change from say Black to Red when (Finished) is
    selected!


    Thanks in advance.........Bob Vance
     
  2. Loading...


  3. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Use Conditional Formatting. In form Design View, select the combo box. From
    the Format menu, select Conditional Formatting, and set the format when the
    Value is equal to "Finished"
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Bob" <xxx@xx.xx> wrote in message news:e725kp$j3t$1@lust.ihug.co.nz...
    >
    >
    > I have a Combo Box that has 2 Options from Row Source (Active,Finished),
    > How can I get the Font to change from say Black to Red when (Finished) is
    > selected!
    >
    >
    > Thanks in advance.........Bob Vance
    >
     
  4. Larry Linson

    Larry Linson
    Expand Collapse
    Guest

    "Bob" wrote

    > How can I get the Font to change from
    > say Black to Red when (Finished) is
    > selected!


    Open the Form in Design View, right-click the Combo, and choose Conditional
    Formatting. It seems intuitive to me.

    Larry Linson
    Microsoft Access MVP
     
  5. Bob

    Bob
    Expand Collapse
    Guest

    Thanx Guys, Im not that stupid just forgetful :)

    "Larry Linson" <bouncer@localhost.not> wrote in message
    news:e6Vup8mkGHA.3572@TK2MSFTNGP04.phx.gbl...
    > "Bob" wrote
    >
    > > How can I get the Font to change from
    > > say Black to Red when (Finished) is
    > > selected!

    >
    > Open the Form in Design View, right-click the Combo, and choose
    > Conditional Formatting. It seems intuitive to me.
    >
    > Larry Linson
    > Microsoft Access MVP
    >
     
  6. Bob

    Bob
    Expand Collapse
    Guest

    Is it possible to do the same with a text box, so if cbStatus (Combo Box)
    shows Finished the text will change in a Text Box.....Thanx Bob

    "Bob" <xxx@xx.xx> wrote in message news:e727uf$nas$1@lust.ihug.co.nz...
    > Thanx Guys, Im not that stupid just forgetful :)
    >
    > "Larry Linson" <bouncer@localhost.not> wrote in message
    > news:e6Vup8mkGHA.3572@TK2MSFTNGP04.phx.gbl...
    >> "Bob" wrote
    >>
    >> > How can I get the Font to change from
    >> > say Black to Red when (Finished) is
    >> > selected!

    >>
    >> Open the Form in Design View, right-click the Combo, and choose
    >> Conditional Formatting. It seems intuitive to me.
    >>
    >> Larry Linson
    >> Microsoft Access MVP
    >>

    >
    >
     
  7. Arvin Meyer [MVP]

    Arvin Meyer [MVP]
    Expand Collapse
    Guest

    Yes.
    --
    Arvin Meyer, MCP, MVP
    Microsoft Access
    Free Access downloads
    http://www.datastrat.com
    http://www.mvps.org/access

    "Bob" <xxx@xx.xx> wrote in message news:e728em$o87$1@lust.ihug.co.nz...
    > Is it possible to do the same with a text box, so if cbStatus (Combo Box)
    > shows Finished the text will change in a Text Box.....Thanx Bob
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e727uf$nas$1@lust.ihug.co.nz...
    >> Thanx Guys, Im not that stupid just forgetful :)
    >>
    >> "Larry Linson" <bouncer@localhost.not> wrote in message
    >> news:e6Vup8mkGHA.3572@TK2MSFTNGP04.phx.gbl...
    >>> "Bob" wrote
    >>>
    >>> > How can I get the Font to change from
    >>> > say Black to Red when (Finished) is
    >>> > selected!
    >>>
    >>> Open the Form in Design View, right-click the Combo, and choose
    >>> Conditional Formatting. It seems intuitive to me.
    >>>
    >>> Larry Linson
    >>> Microsoft Access MVP
    >>>

    >>
    >>

    >
    >
     
  8. Bob

    Bob
    Expand Collapse
    Guest

    I tried from the text box did not know how to locate the combo box from
    there? Thanx...Bob

    "Arvin Meyer [MVP]" <a@m.com> wrote in message
    news:OhtMfcnkGHA.3936@TK2MSFTNGP05.phx.gbl...
    > Yes.
    > --
    > Arvin Meyer, MCP, MVP
    > Microsoft Access
    > Free Access downloads
    > http://www.datastrat.com
    > http://www.mvps.org/access
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e728em$o87$1@lust.ihug.co.nz...
    >> Is it possible to do the same with a text box, so if cbStatus (Combo Box)
    >> shows Finished the text will change in a Text Box.....Thanx Bob
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e727uf$nas$1@lust.ihug.co.nz...
    >>> Thanx Guys, Im not that stupid just forgetful :)
    >>>
    >>> "Larry Linson" <bouncer@localhost.not> wrote in message
    >>> news:e6Vup8mkGHA.3572@TK2MSFTNGP04.phx.gbl...
    >>>> "Bob" wrote
    >>>>
    >>>> > How can I get the Font to change from
    >>>> > say Black to Red when (Finished) is
    >>>> > selected!
    >>>>
    >>>> Open the Form in Design View, right-click the Combo, and choose
    >>>> Conditional Formatting. It seems intuitive to me.
    >>>>
    >>>> Larry Linson
    >>>> Microsoft Access MVP
    >>>>
    >>>
    >>>

    >>
    >>

    >
    >
     
  9. fredg

    fredg
    Expand Collapse
    Guest

    On Sun, 18 Jun 2006 13:35:09 +1200, Bob wrote:

    > I tried from the text box did not know how to locate the combo box from
    > there? Thanx...Bob
    >
    > "Arvin Meyer [MVP]" <a@m.com> wrote in message
    > news:OhtMfcnkGHA.3936@TK2MSFTNGP05.phx.gbl...
    >> Yes.
    >> --
    >> Arvin Meyer, MCP, MVP
    >> Microsoft Access
    >> Free Access downloads
    >> http://www.datastrat.com
    >> http://www.mvps.org/access
    >>
    >> "Bob" <xxx@xx.xx> wrote in message news:e728em$o87$1@lust.ihug.co.nz...
    >>> Is it possible to do the same with a text box, so if cbStatus (Combo Box)
    >>> shows Finished the text will change in a Text Box.....Thanx Bob
    >>>
    >>> "Bob" <xxx@xx.xx> wrote in message news:e727uf$nas$1@lust.ihug.co.nz...
    >>>> Thanx Guys, Im not that stupid just forgetful :)
    >>>>
    >>>> "Larry Linson" <bouncer@localhost.not> wrote in message
    >>>> news:e6Vup8mkGHA.3572@TK2MSFTNGP04.phx.gbl...
    >>>>> "Bob" wrote
    >>>>>
    >>>>> > How can I get the Font to change from
    >>>>> > say Black to Red when (Finished) is
    >>>>> > selected!
    >>>>>
    >>>>> Open the Form in Design View, right-click the Combo, and choose
    >>>>> Conditional Formatting. It seems intuitive to me.
    >>>>>
    >>>>> Larry Linson
    >>>>> Microsoft Access MVP
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >>
    >>


    Set the Condition1 for the Text control to:
    Expression Is
    Write:
    [cbStatus] = "Finished"
    in the dialog box.

    Select your colors and save the changes.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
  10. Bob

    Bob
    Expand Collapse
    Guest

    BRILLIANT Fred Thanks very much!!

    "fredg" <fgutkind@example.invalid> wrote in message
    news:1ep1bs97zt05.1jiv0yeztefes$.dlg@40tude.net...
    > On Sun, 18 Jun 2006 13:35:09 +1200, Bob wrote:
    >
    >> I tried from the text box did not know how to locate the combo box from
    >> there? Thanx...Bob
    >>
    >> "Arvin Meyer [MVP]" <a@m.com> wrote in message
    >> news:OhtMfcnkGHA.3936@TK2MSFTNGP05.phx.gbl...
    >>> Yes.
    >>> --
    >>> Arvin Meyer, MCP, MVP
    >>> Microsoft Access
    >>> Free Access downloads
    >>> http://www.datastrat.com
    >>> http://www.mvps.org/access
    >>>
    >>> "Bob" <xxx@xx.xx> wrote in message news:e728em$o87$1@lust.ihug.co.nz...
    >>>> Is it possible to do the same with a text box, so if cbStatus (Combo
    >>>> Box)
    >>>> shows Finished the text will change in a Text Box.....Thanx Bob
    >>>>
    >>>> "Bob" <xxx@xx.xx> wrote in message news:e727uf$nas$1@lust.ihug.co.nz...
    >>>>> Thanx Guys, Im not that stupid just forgetful :)
    >>>>>
    >>>>> "Larry Linson" <bouncer@localhost.not> wrote in message
    >>>>> news:e6Vup8mkGHA.3572@TK2MSFTNGP04.phx.gbl...
    >>>>>> "Bob" wrote
    >>>>>>
    >>>>>> > How can I get the Font to change from
    >>>>>> > say Black to Red when (Finished) is
    >>>>>> > selected!
    >>>>>>
    >>>>>> Open the Form in Design View, right-click the Combo, and choose
    >>>>>> Conditional Formatting. It seems intuitive to me.
    >>>>>>
    >>>>>> Larry Linson
    >>>>>> Microsoft Access MVP
    >>>>>>
    >>>>>
    >>>>>
    >>>>
    >>>>
    >>>
    >>>

    >
    > Set the Condition1 for the Text control to:
    > Expression Is
    > Write:
    > [cbStatus] = "Finished"
    > in the dialog box.
    >
    > Select your colors and save the changes.
    > --
    > Fred
    > Please respond only to this newsgroup.
    > I do not reply to personal e-mail
     

Share This Page