Was wondering if anyone has come across this problem. I currently have an access front and an access back end. Every once in a while there seems to be a value cleared out of a particular field. The field is called "assigned" and is a text field that can allow for nulls (requirement). anyhow code and properties is in place that prevents that field from being cleared on the form and on the event procedure level once that field has been entered. At this point I do not believe anyone is tampering with the data at the table level.

So my question to anyone who might know is this.. Is there a bug in access that loses data in a record every once in a while?

SP1 and SP2 is installed.