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.
- Open the table that contains the field in Design view.
- Click the field in which you want to enter a zero-length string.
- Set the AllowZeroLength field property to Yes.