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.”
- Custom Reports in QuickBooks Online: Overview ...
- Change Orders in Sage 50: Overview ...
- Categorize an Item in Outlook on the Web: Overv...
- Write Checks in Sage 50: Overview T...
- Create a Mailbox Rule in Outlook: Overview ...
- 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