Auto number displays in access table instead of my descriptions.

[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.

 

[Gina Whipp]

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.

 

[John W. Vinson]

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.

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