Database Object.
You can use the V1xNullBehavior property to specify whether zero-length strings ("") used in code to fill Text or Memo fields are converted to Null.
Note This property applies only to Microsoft Access version 1.x databases that have been converted to Microsoft Access version 2.0 databases and that contain such code. Microsoft Access automatically creates this property when it converts a version 1.x database to a version 2.0 database.
The V1xNullBehavior property uses the following settings.
|
Setting |
Description |
|
True (-1) |
Zero-length strings are converted to Null. |
|
False (0) |
Zero-length strings aren’t converted to Null. |
You can set this property only using Visual Basic.
Note If you change the setting for this property, 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 the fields are set to Null, and remove the property from the Properties collection.
AllowZeroLength Property, V1xNullBehavior Property (Microsoft Office 95 Data Access Reference).