An Access 2000/2003 database has a form containing a memo field. Periodically the value of the memo field will show as #Deleted while the record itself is fine. The #Deleted value interferes with reports and an automated process.
To correct the record, I have to recreate it and delete the old. Is there any way on the form, I can allow users to enter and edit, but not delete the value?
1. Place your table in design view and highlight your memo field. Go to the property pane in the lower half of your screen and set the allow zero length strings to "No" ......this prevents a memo field from allowing just spaces with nothing else typed in.
2. Go to the validation rule property and type the following: Is Not Null
3. Go to the validation text property and type the message you want displayed if the validation rule is violated: You can't leave this field blank.
4, Save your changes.....keep in mind that if any records violate this rule, you will have to fix before you can save your changes above. So it is best if you query your database first, fix the violations, and then do steps one thru 3 above.