Ready to Checkout?

shopping-cart

Try the Access Course for Free!

Hide a Query Field in Access – Instructions

by / Thursday, 03 August 2017 / Published in Access 2013, Access 2016, Latest, Microsoft, Office 2013, Office 2016, Office 365

Hide a Query Field in Access: Overview

            You can easily hide a query field in Access. Sometimes when you create queries, you need to add a field to the QBE grid for criteria purposes only. In this case, you don’t want the field itself to appear in the result set. Having additional fields appear in the result set can slow down query performance. However, if the field is required for sorting or criteria purposes, it must be included in the QBE grid.

            To hide a query field in Access, open the query that contains the field to hide from the result set in query design view. Then, in the QBE Grid, uncheck the checkbox in the “Show:” row of the field you want to hide. Then click the “Save” button in the Quick Access toolbar to save your changes.

            This field will still function as a query criteria field. You can also still sort by its values in the QBE Grid. However, its data will not appear within the result set.

Hide a Query Field in Access - Instructions: A picture of a hidden field in a query, shown within the query design view in Access.

Hide a Query Field in Access – Instructions: A picture of a hidden field in a query, shown within the query design view in Access.

Hide a Query Field in Access: Instructions

  1. To hide a query field in Access, open the query that contains the field to hide from the result set in query design view.
  2. Then, in the QBE Grid, uncheck the checkbox in the “Show:” row of the field you want to hide.
  3. Then click the “Save” button in the Quick Access toolbar to save your changes.

Hide a Query Field in Access: Video Lesson

            The following video lesson, titled “Hiding Fields in a Result Set,” shows you how to hide query fields in Access. This video lesson is from our complete Access tutorial, titled “Mastering Access Made Easy v.2016-2013.”

TOP