hidden fields on query design view???

[Michael Donahoe]

I have a database that I inherited that has query in it that has
hidden fields when it is in design view. Datasheet view shows the
fields and when I switch back to design view it appears as though
those columns are compressed. If I try clicking between the columns
"<-|->" it does not do anything. I don't have 'Format' in the menu
bar to unhide any of the fields for design view.

Does anyone know how to unhide these columns?

[Wayne Morgan]

Other than trial and error to move them back over, the only other thing I
can think of would be to go into SQL view, copy the text, place it in a new
query, delete the old query, and save the new one with the name of the old
one.

--
Wayne Morgan
MS Access MVP
"Michael Donahoe" <mi*****@mdonahoe.com> wrote in message
news:48**************************@posting.google.c om...

I have a database that I inherited that has query in it that has
hidden fields when it is in design view. Datasheet view shows the
fields and when I switch back to design view it appears as though
those columns are compressed. If I try clicking between the columns
"<-|->" it does not do anything. I don't have 'Format' in the menu
bar to unhide any of the fields for design view.

Does anyone know how to unhide these columns?

[Rick Brandt]

"Michael Donahoe" <mi*****@mdonahoe.com> wrote in message
news:48**************************@posting.google.c om...

I have a database that I inherited that has query in it that has
hidden fields when it is in design view. Datasheet view shows the
fields and when I switch back to design view it appears as though
those columns are compressed. If I try clicking between the columns
"<-|->" it does not do anything. I don't have 'Format' in the menu
bar to unhide any of the fields for design view.

Does anyone know how to unhide these columns?

Are you sure the "Output All Fields" option is not set to "Yes"? That
forces all fields in the input tables to be included in the output even if
they are not pulled down into the design grid.
--
I don't check the Email account attached
to this message. Send instead to...
RBrandt at Hunter dot com