Access is deleting data

A

Anthroslug

I have a database where the data in one of the fields in one table keeps
vanishing. Every time I re-open the database, that field is empty,
regardless of what data I had entered the last time I had the database open.
Does anyone have any idea why this would happen?
 
J

John Vinson

I have a database where the data in one of the fields in one table keeps
vanishing. Every time I re-open the database, that field is empty,
regardless of what data I had entered the last time I had the database open.
Does anyone have any idea why this would happen?
Click to expand...

If it's disappearing from a Form, perhaps it is an unbound textbox
(rather than being stored in a table), or perhaps the Form is based on
a Query and the query is such that the field is not being stored (or
not being displayed after it's stored).

More details please! What's the datatype of the field? Does it
disappear if you enter it in table datasheet view, or only using a
form or query? If a query, what's the SQL of the query?

John W. Vinson[MVP]
 
Top