Missing Columns in Datasheet View

[mikel]

I was working on my database and opened one of my tables in datasheet view and noticed that I was missing some columns. I switced to design view and all of the fields are there. So, why doesn't datasheet view show all of my columns (fields)? Is there a setting somewhere that hides them?

[retro]

In Access 2003 at least, Format > Unhide Columns.

I haven't used 2007 in a while, but IIRC it was a bit like Excel - select an adjacent column and there's an unhide option on the right-click menu.

Hope this helps. If the above doesn't apply for 2007, try searching the in-built help for unhide columns.

[mikel]

Thanks that worked. I can't believe I didn't see that.

[warminster100]

Hi Mikel:
I have a similar problem with a column in a table (using access 2003). I hid this column and several others in order to enter data easier. When I did the "unhide columns" all columns but this one were restored. I checked the "design view" and the column is still in the table. Tried right-click on an adjacent field but the option is only to "hide columns". The column in question is indexed.
Can you help?
Thanks
regc