Make a field accept zero-length strings (MDB)

Microsoft Office Access 2003

Show All Show All

Make a field accept zero-length strings (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

Only Text, Memo, and Hyperlink fields can accept zero-length strings.

  1. Open the table that contains the field in Design view.
  2. Click the field in which you want to enter a zero-length string.
  3. Set the AllowZeroLength field property to Yes.