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" <(E-Mail Removed)> wrote in message
news:518F7DC7-32D3-454D-9D92-(E-Mail Removed)...
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
<(E-Mail Removed)> 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]