If/then with blank field and checkbox
Hello friends, question about a field that used to work for me but no longer does.
In one form, one field will either be blank or have a number in it, we'll call it "tag number". If "tag number...
Forum Discussion
If Tag Number is actually a Numeric field - you can also user the Nz() function. It will return 0 if the value is entered as 0 or null - basically a way to force it to render as 0 in all cases. You could then do if( Nz([Tag Number]) > 0, true, false)
------------------------------
Chayce Duncan
------------------------------
thank you, everyone! the second option worked, and then I just flipped the true,false to false, true and that worked! thank you both for your help! I'll be able to use the first option I believe with another challenge. Thank you!!!
------------------------------
Nicole Cordeiro
------------------------------