Welcome to SPN

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

Sign Up Now!

Conditional Formatting Question

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

  1. Bob

    Bob
    Expand Collapse
    Guest

    If there is no data in a text box I want it to turn red, what code would I
    use!
    Thanks in advance.........Bob Vance
     
  2. Loading...

    Similar Threads Forum Date
    Inspirational Unconditional love for the Guru Videos Sep 4, 2010
    General Unconditional Love Hard Talk Jun 28, 2008
    Pure and Unconditional Love for God Gurmat Vichaar Feb 18, 2008

  3. Allen Browne

    Allen Browne
    Expand Collapse
    Guest

    Assuming Access 2000 or later, you can do it without code:

    1. Open the form in design view.

    2. Select the text box that will go red.
    (We will assume it is named Text0 for this example.)

    3. Choose Conditional Formatting on the Format menu.

    4. Set Condition 1 to:
    Expression [Text0] Is Null

    --
    Allen Browne - Microsoft MVP. Perth, Western Australia.
    Tips for Access users - http://allenbrowne.com/tips.html
    Reply to group, rather than allenbrowne at mvps dot org.

    "Bob" <xxx@xx.xx> wrote in message news:e7sk0j$nf7$1@lust.ihug.co.nz...
    >
    > If there is no data in a text box I want it to turn red, what code would I
    > use!
    > Thanks in advance.........Bob Vance
     
  4. Bob

    Bob
    Expand Collapse
    Guest

    Thanks Allen Brilliant.....Bob

    "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
    news:%23CoNSJlmGHA.1552@TK2MSFTNGP04.phx.gbl...
    > Assuming Access 2000 or later, you can do it without code:
    >
    > 1. Open the form in design view.
    >
    > 2. Select the text box that will go red.
    > (We will assume it is named Text0 for this example.)
    >
    > 3. Choose Conditional Formatting on the Format menu.
    >
    > 4. Set Condition 1 to:
    > Expression [Text0] Is Null
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e7sk0j$nf7$1@lust.ihug.co.nz...
    >>
    >> If there is no data in a text box I want it to turn red, what code would
    >> I use!
    >> Thanks in advance.........Bob Vance

    >
    >
     
  5. Bob

    Bob
    Expand Collapse
    Guest

    Thanks Allen Brilliant.....Bob
    "Allen Browne" <AllenBrowne@SeeSig.Invalid> wrote in message
    news:%23CoNSJlmGHA.1552@TK2MSFTNGP04.phx.gbl...
    > Assuming Access 2000 or later, you can do it without code:
    >
    > 1. Open the form in design view.
    >
    > 2. Select the text box that will go red.
    > (We will assume it is named Text0 for this example.)
    >
    > 3. Choose Conditional Formatting on the Format menu.
    >
    > 4. Set Condition 1 to:
    > Expression [Text0] Is Null
    >
    > --
    > Allen Browne - Microsoft MVP. Perth, Western Australia.
    > Tips for Access users - http://allenbrowne.com/tips.html
    > Reply to group, rather than allenbrowne at mvps dot org.
    >
    > "Bob" <xxx@xx.xx> wrote in message news:e7sk0j$nf7$1@lust.ihug.co.nz...
    >>
    >> If there is no data in a text box I want it to turn red, what code would
    >> I use!
    >> Thanks in advance.........Bob Vance

    >
    >
     

Share This Page