From: size5snoopy on
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.
From: Gina Whipp on
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" <size5snoopy(a)discussions.microsoft.com> wrote in message
news:518F7DC7-32D3-454D-9D92-205D1F425497(a)microsoft.com...
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.

From: John W. Vinson on
On Wed, 17 Mar 2010 13:41:01 -0700, size5snoopy
<size5snoopy(a)discussions.microsoft.com> 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]