#Name? What does this mean?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Seen this out here before, but I have never seen an answer. What is this. I
have entered all of the criteria for a query, and it opens up, but when I
scroll across the columns I seem to reach one that casues all of the data in
all of the fields to be converted to #Name?. Thanks
 
Somewhere you've typed in the name of a field that isn't there at all or not
exactly right.

Other than that, maybe the database is corrupt. Do a Compact and Repair and
see if that fixes it.
 
The Compact and Repair didn't do it, but I removed one field called notes and
that seemed to stabilize the data. Thanks for your help.
 
I bet that Notes was a Memo data type. Memo fields are known to corrupt and
often compact and repair won't fix them. I avoid Memo fields for that reason
and make frequent backups when they are required.
 
Back
Top