V1xNullBehavior Property

Indicates whether zero-length strings ("") used in code to fill Text or Memo fields are converted to Null.

Settings and Return Values

The setting or return value is a Boolean that is True if zero-length strings are converted to Null.

Remarks

This property applies to Microsoft Jet database engine version 1.x databases that have been converted to Microsoft Jet database engine version 2.0 or 3.0 databases.

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

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.