Why doiesn't my primary key show up on a datasheet view?

[Ed Mattison]

I have an ordinary table with 20 fields and in the design view the primary field is shown as an autonumber, but it doesn't appear in the datasheet view. This never happened to me before. Thanks for any ideas you can give me. Ed

[June7]

This is when viewing table directly?

Fields can be set as hidden. Cursor over any field header and right click then choose Hide or Unhide.

[JamesDeckert]

My first thought is the hidden column, but you can also not see a column if you're opening a query instead of a table. If you're opening the table directly this won't be the case, but if a button is opening the table, it could be a query instead.

[June7]

Yes, fields in table can be hidden, even when opening the table directly.

[Ed Mattison]

Thanks to everyone. I clicked on unhide all and the primary key showed up. But how could I just have unhid the primary key. I tried hovering where the field name should be, but nothing showed up. Anyhow, I won't make that mistake again thanks to you. Ed