• Conditional Formatting a report (Access03)

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Conditional Formatting a report (Access03)

    Author
    Topic
    #457153

    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

    Viewing 0 reply threads
    Author
    Replies
    • #1145226

      Why are you using the the “Expression Is” condition? You should be using the “Field Value Is”.

      • #1145231

        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

    Viewing 0 reply threads
    Reply To: Conditional Formatting a report (Access03)

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information: