Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page