Posted on 2011-03-23
I have a bunch of fields that are requiring "N/A" if the end user hasn't entered any data. The code I'm using for the source is as follows.
=IIf([Close Date]<=0,"N/A",[Close Date])
Now, this works for numbers but not for text entries. How can I edit this code to work for text entries?