List Box Values (Null Values)

[#1]

Hi - I have an issue where the data I have looks like the below:

ID          Fruit Type

1            Apple

2            Banana

3

4            Pear

5            Apple

6

7            Pear

8            Banana

Right now, the list box only offers the following values: Apple, Banana and Pear

However, I want it to list: Apple, Banana, Pear and  - / null value / undefined (however it can be displayed)

My developer is telling me that this would be a considerable fix, but based on my designer training, I get the feeling this is more of a setting than anything else.  Can someone please help?

[tresesco]

Use NullAsValue in the script.

Example:

NullAsValue A,B;                     // A,B are fields

Set NullValue = 'NULL' ;