Forum Discussion
AnnettaColeman
3 years agoQrew Cadet
Well Duh.... It works just fine if I use <> Null instead of IsNull = False. Amazing what clarity can be discovered via a Power Nap. Sorry to waste community time.
------------------------------
Annetta Coleman
------------------------------
------------------------------
Annetta Coleman
------------------------------
- MarkShnier__You3 years agoQrew LegendI just a tip. You can't use IsNull to test for a Text field type being blank. I use this
IF(Trim([My Text field]) = "", ............)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - MikeTamoush3 years agoQrew CommanderTo add on to Mark's tip:
If you ARE testing a numerical field simply use:
isnull([Field]) to test if blank
not isnull([Field]) to test if not blank (versus isnull <>null....)
------------------------------
Mike Tamoush
------------------------------