Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Conditional Formatting a report (Access03)

    I want a report's text box conditinally formatted so if the date is betwen now and the next three months that area will be shaded green. I got the following expression to work on a query grid. But, in the expression is box for the conditional formatting I get an invalid syntax error.

    Here is my expression:

    Between Now() AND DateSerial(Year(Now()),Month(Now())+3,Day(Now()))

    Any help would be appreciated.

    Fay

  2. #2
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Conditional Formatting a report (Access03)

    Why are you using the the "Expression Is" condition? You should be using the "Field Value Is".
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    5 Star Lounger
    Join Date
    Jul 2001
    Location
    NJ, USA
    Posts
    617
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Conditional Formatting a report (Access03)

    To close to it. Didn't think I could use an expression in the Field Value is area. Stupid of me. Thanks I got it working. Fay

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •