Auto number displays in access table instead of my descriptions.

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

"size5snoopy" wrote in message
...
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.

On Wed, 17 Mar 2010 13:41:01 -0700, size5snoopy
wrote:

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

John W. Vinson [MVP]