2007 -not all table fields show in reg View

[Cindy B]

Hope someone can help me with this....
We just upgraded to Access 2007, we are opening a DB created in 2003 and
leaving it as an .mdb file. This is a simple 2 table DB used for inventory.
When I open the table, there are 45 fields in design view - but only 33
display in the regular table view. I haven't found a common setting yet???
Does anyone have any idea what might cause that? or how I can correct it?
The data is still there - when I open the reports/querries it is OK.
We have staff pretty nervous about this upgrade, so I'm hoping for a quick
fix before it becomes an issue... Any help/suggestoins greatly
appreciated!!!!
Thanks for time and help!!!!

 

[Cheese_whiz]

Hi Cindy,

Open up the table in datasheet view and right click on one of the column
headers and choose 'unhide columns'.

HTH,
CW

 

[Cheese_whiz]

PS: Datasheet view is what you are calling 'regular' view.

CW

 

[Cindy B]

Thank - you!!!!!
Sounds like an Excel function... I didn't even know that Access had column
hide capabilities.

Thanks again - you made my day brighter!

 

[José DUPUIS]

Hope someone can help me with this....
We just upgraded to Access 2007, we are opening a DB created in 2003 and
leaving it as an .mdb file. This is a simple 2 table DB used for
inventory.
When I open the table, there are 45 fields in design view - but only 33
display in the regular table view. I haven't found a common setting
yet???
Does anyone have any idea what might cause that? or how I can correct it?
The data is still there - when I open the reports/querries it is OK.
We have staff pretty nervous about this upgrade, so I'm hoping for a quick
fix before it becomes an issue... Any help/suggestoins greatly
appreciated!!!!
Thanks for time and help!!!!

 

[John W. Vinson]

Thank - you!!!!!
Sounds like an Excel function... I didn't even know that Access had column
hide capabilities.

Thanks again - you made my day brighter!
--

Not to mention your screen... all those extra columns! <g>

 

[Sjaco den Haan]

Hope someone can help me with this....
We just upgraded to Access 2007, we are opening a DB created in 2003 and
leaving it as an .mdb file. This is a simple 2 table DB used for
inventory.
When I open the table, there are 45 fields in design view - but only 33
display in the regular table view. I haven't found a common setting
yet???
Does anyone have any idea what might cause that? or how I can correct it?
The data is still there - when I open the reports/querries it is OK.
We have staff pretty nervous about this upgrade, so I'm hoping for a quick
fix before it becomes an issue... Any help/suggestoins greatly
appreciated!!!!
Thanks for time and help!!!!