none
Conditiional Formatting question RRS feed

  • Question

  • I have a simple Access 2013 DB that I want to apply conditional formatting to.

    This is what I have

    My field value is a null value, I have verified it.  In immediate window,

    ? me.DateDue
    Null

    However, the rule doesn't work.  Any help?


    • Edited by tkosel Wednesday, December 6, 2017 5:21 PM
    Wednesday, December 6, 2017 5:18 PM

Answers

  • Hi,

    Unfortunately, Null basically means "unknown," so it cannot be equal to anything. So, for null values, you'll need to use either Is Null or the IsNull() function. For example:

    Value Is Null

    or

    Expression: IsNull(DateDue)

    Hope it helps...


    • Edited by .theDBguy Wednesday, December 6, 2017 5:21 PM
    • Marked as answer by tkosel Wednesday, December 6, 2017 5:39 PM
    Wednesday, December 6, 2017 5:21 PM
  • Let the Wizard convert it to Expression is IsNull(DueDate) and just see if it works. Let us know...
    • Marked as answer by tkosel Wednesday, December 6, 2017 5:40 PM
    Wednesday, December 6, 2017 5:34 PM

All replies

  • Hi,

    Unfortunately, Null basically means "unknown," so it cannot be equal to anything. So, for null values, you'll need to use either Is Null or the IsNull() function. For example:

    Value Is Null

    or

    Expression: IsNull(DateDue)

    Hope it helps...


    • Edited by .theDBguy Wednesday, December 6, 2017 5:21 PM
    • Marked as answer by tkosel Wednesday, December 6, 2017 5:39 PM
    Wednesday, December 6, 2017 5:21 PM
  • As usual, thank you for your prompt reply. 

    I still cannot get it to work.  The conditional formatting wizard will not let me use  Expression: IsNull(DateDue) because it turns it into "Expression is IsNull(DateDue)"

    Guess I am kind of dumb huh?  What am I missing?

    Wednesday, December 6, 2017 5:28 PM
  • Let the Wizard convert it to Expression is IsNull(DueDate) and just see if it works. Let us know...
    • Marked as answer by tkosel Wednesday, December 6, 2017 5:40 PM
    Wednesday, December 6, 2017 5:34 PM
  • That works, thanks again.
    Wednesday, December 6, 2017 5:40 PM
  • Hi,

    You're welcome. Sorry for the confusion. Good luck with your project.

    Wednesday, December 6, 2017 5:56 PM