| True DataControl 8.0 Reference > True DataControl Control > TData Control Properties > ConvertNullToEmpty Property |
ConvertNullToEmpty Property
Specifies if Null values of string fields should be converted to empty strings on retrieval.
TData.ConvertNullToEmpty = boolean
Read/Write at run time and design time. Property applies to TData control and TDataLite control.
If set to True (default), this property makes TData convert Null values of string fields read from the data source to empty string. This make it easier to deal with such values in expressions and code, since VBScript and Visual Basic expressions have special behavior on Null values, which is usually undesirable, and empty strings are easier to handle. Non-string fields are not affected by this property. If you need to convert Nulls to some particular values for such fields, use the DataRead event. For more information, see Modifying Field Values Retrieving and Saving Them in the Data Source.
Note: At design time, this property is not available in the property pages and must be set in the Visual Basic Properties window.
See Also