V1xNullBehavior Property

Applies To

Database Object.

Description

Sets or returns a value that indicates whether zero-length strings ("") used in code to fill Text or Memo fields are converted to Null. This property applies to Microsoft Jet database engine version 1.x databases that have been converted to Jet database engine version 2.0 or 3.0 databases.

Note The Jet database engine automatically creates this property when it converts a version 1.x database to a version 2.0 or 3.0 database. A 2.0 database will retain this property when it is converted to a 3.0 database.

Settings and Return Values

The setting or return value is a Boolean expression that indicates whether zero-length strings are converted to Null. The data type is Boolean. True (-1) indicates that zero-length strings are converted to Null.

Remarks

If you change this property setting, you must close and then reopen the database for your change to take effect.

For fastest performance, modify code that sets any Text or Memo fields to zero-length strings so that the fields are set to Null instead, and remove the V1xNullBehavior property from the Properties collection.