Hide a Query Field in Access – Instructions
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.
Instructions on How to Hide a Query Field in Access
- 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.