• 1
  • 1
  • Question
  • Updated 9 months ago
  • Answered

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
Photo of yaniv yaniv

yaniv yaniv

  • 72 Points

Posted 2 years ago

  • 1
  • 1
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)
Photo of Lee Gilmore

Lee Gilmore

  • 790 Points 500 badge 2x thumb
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!