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?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.
Similar Threads
  1. Guest

    Expression Results in Truncated Fraction

    Guest, Sep 17, 2004, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    372
    John Spencer (MVP)
    Sep 18, 2004
  2. Guest

    Use result of expression in another expression??

    Guest, Jan 14, 2007, in forum: Microsoft Access Queries
    Replies:
    9
    Views:
    1,093
    Smartin
    Jan 15, 2007
  3. Sue Compelling

    Query using expression for criteria retunring no results for one u

    Sue Compelling, Dec 13, 2007, in forum: Microsoft Access Queries
    Replies:
    2
    Views:
    205
    Sue Compelling
    Dec 14, 2007
  4. Susan

    Expression too complex in query expression

    Susan, Feb 3, 2008, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    2,252
    John W. Vinson
    Feb 4, 2008
  5. Marktheshark

    Select Reccords based on Expression Results

    Marktheshark, Sep 2, 2008, in forum: Microsoft Access Queries
    Replies:
    3
    Views:
    332
    John Spencer
    Sep 3, 2008
  6. Steve D
    Replies:
    7
    Views:
    394
    John Spencer
    Oct 3, 2008
  7. NG

    RE: Expression too complex in query expression

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

    Re: Expression too complex in query expression

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