Welcome to SPN

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

Sign Up Now!

Conditional format expression

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

  1. lmv

    lmv
    Expand Collapse
    Guest

    I have a notes field if there is nothing in the field I want no color... if
    there is any text I want a color. I don't know what to put in the expression
    of the Access Conditional Formatting
    tried:

    "IsNotNull"
    "NotNull"

    Please help!
    Thanks
     
  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
    India Indian ‘Journalist’ Slams Gurbaksh Singh Than Admits to Receiving Information from ‘Agencies’ Breaking News Dec 27, 2013
    Opinion West Punjab : Information Pool and Pictures Punjab, Punjabi, Punjabiyat Nov 18, 2013

  3. Michael H

    Michael H
    Expand Collapse
    Guest

    Hi.

    I assume this is for a TextBox control (bound to a Memo field called
    "Notes") on a form.
    In Design mode, make sure you select the control for the Notes field before
    you click on Format/Conditional Formatting.
    In the first Combo Box in the Conditional Formatting window, select
    "Expression Is".
    In the TextBox next to it, type: Not (IsNull([Notes]))
    Then, make sure you choose the color you want your text box to be if the
    Notes field is not Null.

    -Michael



    "lmv" wrote:

    > I have a notes field if there is nothing in the field I want no color... if
    > there is any text I want a color. I don't know what to put in the expression
    > of the Access Conditional Formatting
    > tried:
    >
    > "IsNotNull"
    > "NotNull"
    >
    > Please help!
    > Thanks
    >
    >
     
  4. lmv

    lmv
    Expand Collapse
    Guest

    THANK YOU! That's it! Now can you look at my "scrollbar problem" question? ;)

    "Michael H" wrote:

    > Hi.
    >
    > I assume this is for a TextBox control (bound to a Memo field called
    > "Notes") on a form.
    > In Design mode, make sure you select the control for the Notes field before
    > you click on Format/Conditional Formatting.
    > In the first Combo Box in the Conditional Formatting window, select
    > "Expression Is".
    > In the TextBox next to it, type: Not (IsNull([Notes]))
    > Then, make sure you choose the color you want your text box to be if the
    > Notes field is not Null.
    >
    > -Michael
    >
    >
    >
    > "lmv" wrote:
    >
    > > I have a notes field if there is nothing in the field I want no color... if
    > > there is any text I want a color. I don't know what to put in the expression
    > > of the Access Conditional Formatting
    > > tried:
    > >
    > > "IsNotNull"
    > > "NotNull"
    > >
    > > Please help!
    > > Thanks
    > >
    > >
     

Share This Page