How do I unhide coumns in Access hidden by another user?

[Debbie Tennent]

A colleague has changed the view of a query in an Access database by hiding
coumns and then saving that layout. I want to unhide the columns but Access
doesn't give the option via the Format menu.

Is there any way to reinstate these columns in the query?

 

[Beetle]

If you mean that someone went into design view and deselected the
Show option of the columns, and if there was no criteria based on those
columns, then they likely weren't "hidden" but rather removed from
the query entirely. You would have to add them back in from the
available fields in the table(s) that the query is based on.

If there was criteria based on those fields, then they should still be there
but probably would have been moved to the end of the query (to the
far right in the design grid) since they are only criteria and not part
of the SELECT clause.

 

[John Spencer]

If you mean your colleague used the format menu to hide columns, then Open the
query in datasheet view, select Format: Unhide columns from the menu and check
the unchecked columns.

OR Right-click the title bar of the query in datasheet view and select Unhide
columns from the list of choices (usually it will be the bottom choice).

If he removed the columns in query design view, then you will have to follow
advice below.

John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County