Indicate nonexistent data with a zero-length string

Microsoft Office Access 2003

Show All Show All

Indicate nonexistent data with a zero-length string

To indicate nonexistent data in a Microsoft Access database, you can enter a zero-length string into a Text or Memo field. In a Microsoft Access project that is connected to a Microsoft SQL Server database, you can enter a zero-length string in a field whose data type is varchar or nvarchar.

  1. Open a datasheet, or open a form in Form view.
  2. To enter a zero-length string in the field, type two double quotation marks without a space in between (" ").

The field remains a zero-length string, even though the quotation marks disappear when you move to another field or object.