Hide a Query Field in Access – Instructions
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
- 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.
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.”
- The Recompose Tool in Photoshop Elements: Overv...
- Print a Report in QuickBooks Pro: Overview ...
- Apply Fills in Photoshop Elements: Overview ...
- The Style Inspector Pane in Word: Overview ...
- Find New Content in Shared Notebooks in OneNote...
- Access 2010
- Access 2013
- Access 2016
- CPE Information for CPAs
- Crystal Reports
- Excel 2010
- Excel 2013
- Excel 2016
- Internet Explorer
- Microsoft Edge
- Microsoft Excel Training for Lawyers
- Microsoft Office Online
- Microsoft Outlook Training for Lawyers
- Microsoft Word Training for Lawyers
- Office 2010
- Office 2013
- Office 2016
- Office 365
- OneNote 2013
- OneNote 2016
- Outlook 2010
- Outlook 2013
- Outlook 2016
- Outlook on the Web
- Photoshop Elements
- PowerPoint 2010
- PowerPoint 2013
- PowerPoint 2016
- Project 2013
- Project 2016
- Publisher 2010
- Publisher 2013
- Publisher 2016
- Quickbooks Online
- QuickBooks Training for Lawyers
- Resume Writing
- Small Business Accounting
- What's New at TeachUcomp?
- Windows 10
- Windows 7
- Windows 8
- Windows 8.1
- Word 2010
- Word 2013
- Word 2016
- Word Online