napsternova
asked on
IIf Alias
Hello,
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?
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?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
first, you have to set the Data type of the field to Text, if it is not set as Text.
ASKER
Easy as pie. Thank you soooo much!
your welcome