Make a field accept zero-length strings

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.