Access "expression",How to change text color relative to results?

Discussion in 'Microsoft Access Queries' started by Guest, May 24, 2007.

  1. Guest

    Guest Guest

    I need to use an expression in query to change the color of the result
    according to status.

    Example: if the date of manufacture exceeds 60 days form today ... the
    number that appear changes to RED ... if not then BLUE.

    This gives the reader a fast color result index.

    Thanks.
     
    Guest, May 24, 2007
    #1
    1. Advertisements

  2. Guest

    fredg Guest

    On Wed, 23 May 2007 19:47:01 -0700, Hamza wrote:

    > I need to use an expression in query to change the color of the result
    > according to status.
    >
    > Example: if the date of manufacture exceeds 60 days form today ... the
    > number that appear changes to RED ... if not then BLUE.
    >
    > This gives the reader a fast color result index.
    >
    > Thanks.


    Queries do not support this type of conditional formatting feature.
    Create a form, based upon the query. Forms controls (in Access 2000 or
    newer) have conditional formatting and you can do this type of thing.
    --
    Fred
    Please respond only to this newsgroup.
    I do not reply to personal e-mail
     
    fredg, May 24, 2007
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Guest

    Use result of expression in another expression??

    Guest, Jan 14, 2007, in forum: Microsoft Access Queries
    Replies:
    9
    Views:
    484
    Smartin
    Jan 15, 2007
  2. Susan

    Expression too complex in query expression

    Susan, Feb 3, 2008, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    1,836
    John W. Vinson
    Feb 4, 2008
  3. Steve D
    Replies:
    7
    Views:
    203
    John Spencer
    Oct 3, 2008
  4. NG

    RE: Expression too complex in query expression

    NG, Aug 12, 2009, in forum: Microsoft Access Queries
    Replies:
    1
    Views:
    424
  5. vanderghast

    Re: Expression too complex in query expression

    vanderghast, Aug 12, 2009, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    1,086
    vanderghast
    Aug 12, 2009
Loading...

Share This Page