Expand all | Collapse all


  • 1.  null

    Posted 04-26-2017 12:06

    my question is if i have numeric field named "num"
    and checkbox (formula)
    in need formula thet if field "num" empty checkbox uncheck, and if it have value checkbox need to be check

  • 2.  RE: null

    Posted 04-26-2017 12:14
    No problem.  First set the field properties for the numeric field [num] to uncheck "treat blank as zero".

    then use the formula

    IF(IsNull([num]), false,true)

  • 3.  RE: null

    Posted 11-28-2018 23:19
    This always bites me! I asked this question months ago and still haven't learned my lesson. I appreciate finding this post to lead me back to that lousy check box!