AnsweredAssumed Answered

Comparing Empty field to 0 returns true

Question asked by flukey on Dec 14, 2018
Latest reply on Dec 15, 2018 by john_wolff

Using FMPA on Windows 10.


I have a number field in a record that is empty (no value entered):

Isempty(Field)  correctly returns 1 (True)

Field = 0  incorrectly returns 1 (True)

Field = 1 correctly returns 0 (False)


Obviously the second result is wrong since an empty field is clearly not = 0.


Is this a new bug?