NullValue Property

       

Sets or returns a value used to format and unformat Null values. Read/write both at design time and run time.

Syntax

object.NullValue [= value]

The NullValue property syntax has these parts:

Part Description
object An object expression that evaluates to an object in the Applies To list.
value Optional Variant. When formatting occurs, if the data is a Null, value is returned. When data is returned to the database, if the data matches value, a Null is written.

Remarks

Ignored when the Type property is set to fmtGeneral. The NullValue property is read each time a null field is fetched.