Conditional formatting for report text box

Posted on 2011-10-13
Last Modified: 2012-05-12
What would be the correct syntax in the Conditoinal formattnig dialog for the below condition?  that is, if the Date in the control is less than Today plus seven AND another control (TaskCompletionDate) on the report is null, then I want this control to be red, bold.

Date()+7 And IsNull([TaskCompletionDate])
Question by:ssmith94015
    LVL 119

    Accepted Solution


    expression is [controlName]= Date() + 7 and  [TaskCompletionDate] Is null
    LVL 61

    Expert Comment

    Use Expression IS, and place the following in the text box:

    [TaskCompletionDate] <= Date()+7 And IsNull([TaskCompletionDate])  = TRUE

    Author Closing Comment

    Thanks Cap, now I need to figure out how to formt the label in red.  But that is aother question.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    The System Center Operations Manager 2012, known as SCOM, is a part of the Microsoft system center product that provides the user with infrastructure monitoring and application performance monitoring. SCOM monitors:   Windows or UNIX/LinuxNetwo…
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
    In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    7 Experts available now in Live!

    Get 1:1 Help Now