Show & Hide field problem

  • Thread starter Thread starter Kaye
  • Start date Start date
K

Kaye

All of a sudden, when in query design, I uncheck 'show'
for a field, save & exit the query, and the field
disappears instead of moving to the far right. When I
come back to add the field again--the field is gone and I
have to remember which fields were there to begin with to
drag them back. Usually, I just have to re-check. Did I
make a change in settings or something? I need all the
fields to stay there--I just want to check and uncheck to
show or hide fields when viewing the query results.
Thank you. Kaye
 
That is the normal behaviour unless the Field has some criteria or it is a
sorting Field.
 
Thanks for responding. However, it has not been my
experience that the field disappears. They have always
moved to the right for me, but now don't. Below is the
text from the Help file, which leads me to think that
they should move to the right rather than disappear. The
last sentence is what I have keyed in on. What do you
think?

"Show or hide a field in a query's results

You can add to the query design grid a field that you use
for setting criteria or a sort order, yet not show the
data from that particular field in the query's results.

· In query Design view, select the Show box in the
design grid to show the field, or clear the Show box to
hide the field.

Notes

· If you want to create a form or report based on
the query, and the query's OutputAllFields property is
set to No, you must show the fields for which you will
create bound controls on the form or report.
· When you close a query, Microsoft Access moves
hidden fields to the rightmost columns in the design
grid."
 
Back
Top