Allow edits but prevent content being entirely deleted. Datasheet form

[Robyn_P]

Hello again. I have a very simple datasheet bound form for data entry. People make mistakes with the data so I want people to be able to go in and directly edit the data. However a couple of times now someone has gone in and decided that a record is no longer needed and just deleted the data contained in it. This is not good. The records may be already used elsewhere and I can't fix it up if I don't know what the original data is, so what I want is a way to prevent people leaving the field value as NULL after their edits. I'm thinking something like copying the original data to a hidden text box in the gotfocus event and then in the after update checking for null and if found, copying the original data back and displaying a warning message explaining why this is happening. Do you think that would work? Can you think of a cleaner method? If a record genuinely isn't needed any more, I need them to delete the whole record not just the field values. Thank-you

[davegri]

How about setting the 'Required' property to YES, and 'Allow zero Length' property to NO in table design for each field?

[Robyn_P]

Yep, that work fine. As a side effect noticed I have a numeric field set as type text in my table. That's silly, don't worry I know how to fix that. Thought there must be a better way. Thanks!