#DELETED shows up in memo field in local table

[Mrs. Ugh]

I have a simple local table containing one memo field and several other
fields. Only one field is linked to another table. On one record, a user
attempted to enter data into the memo field, but once the record attempts to
save, Error 3167 comes up stating that the record is deleted. The other
fields on that record can be edited and saved, but not the memo field (via
the form or directly into the table.) The memo field continues to show
#DELETED. Other records appear to be working fine. Any ideas why this
happened? Any way to get that data entered?

 

[Golfinray]

As a rule, memo fields are not editable. Change it in design view to a text
field.

 

[Douglas J. Steele]

Say what? I've never had issues editing memo fields.

 

[David W. Fenton]

As a rule, memo fields are not editable. Change it in design view
to a text field.

That is an outright falsehood, and terrible, terrible advice.