Auto number displays in access table instead of my descriptions.

  • Thread starter Thread starter size5snoopy
  • Start date Start date
S

size5snoopy

One field in my table keeps showing up as the auto-number instead of the
descriptions for that field. I have tried everything and don't know how to
fix it.
 
size5snoopy,

I'm not sure what you mean... in the table you have a field whose Data Type
is Autonumber but that is not what you want to see?

--
Gina Whipp
2010 Microsoft MVP (Access)

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

One field in my table keeps showing up as the auto-number instead of the
descriptions for that field. I have tried everything and don't know how to
fix it.
 
One field in my table keeps showing up as the auto-number instead of the
descriptions for that field. I have tried everything and don't know how to
fix it.
Click to expand...

That's precisely what the table should show: the actual contents of the table.

What are you expecting? What's the datatype of the field, and what (if
anything) is on its Lookup properties?

Do note that most professionals avoid Lookup Fields and don't let users look
at table datasheets:
http://www.mvps.org/access/lookupfields.htm
 
Back
Top