>>Hi everybody,
>>
>>We're using a special combobox class, which uses 5 as RowSourceType (array). We have NULL in our field table which is a controlsource for the combobox. We should be able to choose this value. The array has NULL in it. However, the combo's value becomes empty (and not NULL) when we switch to this value. (this.aRowSource[this.ListIndex, this.BoundColumn] shows NULL, but value shows empty)
>>
>>Is where a way to fix our class to work correctly with NULLs? Or comboboxes could not handle NULLs at all? Or it's only the problem with certain RowSourceTypes? We could not find anything regarding NULLs in the Help for comboboxes...
>>
>>Our whole application has this serious problem, which I found today accidentally. We need a way to fix the problem.
>>
>>Thanks in advance.
>
>VFP convert every List's item into the SET("NULLDISPLAY") string,
>and put the selected list's item into the controlsource
>( with VAL() conversion for an numeric source )
>
>NULL is not usable
In that case, how about this workaround: have a special string, say "(null)" in the combo for where we should have real nulls, then when saving, if there's this string in the field that's cbo's controlsource, replace that string with a real null.
How bout that?