"Invisible" Columns in ACCESS table

[Harry V]

I have a table that I've imported to Access 2002 SP3 from SQL Server 2000,
and I cannot get two of the columns to display. I've looked in the design
window and at properties, but I see no reason why these two columns shouldn't
display. In a query, I can assign criteria to either column and the results
will be affected by it, but the column will not show up. A qurey on just one
of those columns gives me an empty display. I can see them in SQL Server's
Enterprise Manager, in the original table.

Anyone have a similar problem with a solution?

 

[Rick Brandt]

I have a table that I've imported to Access 2002 SP3 from SQL Server
2000, and I cannot get two of the columns to display. I've looked in
the design window and at properties, but I see no reason why these
two columns shouldn't display. In a query, I can assign criteria to
either column and the results will be affected by it, but the column
will not show up. A qurey on just one of those columns gives me an
empty display. I can see them in SQL Server's Enterprise Manager, in
the original table.

Anyone have a similar problem with a solution?

While looking at the table datasheet go to the menu bar...

Format - Unhide Columns

 

[Harry V]

Thank you, that did the trick. Now I have to find out who the wise guy was...