Try the Access Course for Free!

Hide a Query Field in Access – Instructions

/ / Access 2013, Access 2016, Access 2019, Access for Office 365, Latest, Microsoft, Office 2013, Office 2016, Office 2019, Office 365

How to Hide a Query Field in Access: Video

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

Overview of How to Hide a Query Field in Access

            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 query result set.

A picture showing how to hide a query field in Access.

A picture showing how to hide a query field in Access.

Instructions on How to Hide a Query Field in Access

  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.
TOP