Skip to main content
Question

null

  • April 26, 2017
  • 0 replies
  • 67 views
hello

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
      This topic has been closed for replies.

      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)
      • LeeSGilmore
      • Registered
      • November 29, 2018
      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!
      Terms & ConditionsAccessibility statement