By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,984 Members | 1,461 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,984 IT Pros & Developers. It's quick & easy.

hidden fields on query design view???

P: n/a
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?
Nov 13 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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?

Nov 13 '05 #2

P: n/a
"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
Nov 13 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.