Testing for FALSE works inconsistently

Ask for Help
21

yes, always use is not TRUE

22

AHAH now it works - thank you all - I feel a bit daft now !

23

Yes, thatā€™s what I meant.

1 Like
24

Davidā€™s point was that there could be three states for a boolean:

  • Empty (when you start with a completely new boolean column it may have not been assigned any values)

  • False (when you have pre-assigned a false or switch from true to false)

  • True (when you have pre-assigned a true or switch from false to true)

In your case, your column value seems like an empty rather than a false, hence use is not true instead of false to cover both bases.

3 Likes
25

ā€¦unless of course, you clear it :wink:

1 Like
26

Well donā€™t clear it. :wink:

27

heheā€¦ actually, I do - all the time.
Iā€™ve gotten into the habit of clearing my booleans instead of setting them to false.
So I basically ignore the false state and just check for true/not true.

3 Likes
28

I do - every single word - the same

3 Likes