By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,998 Members | 2,773 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

Memo value on form getting deleted

P: 1
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?
Dec 18 '07 #1
Share this Question
Share on Google+
1 Reply


puppydogbuddy
Expert 100+
P: 1,923
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.
Dec 18 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.