Access 2007 FAQ
How do you remove the drop down arrows that show up with a datasheet form to filter the columns?
In Access 2007, you might have noticed that you if you have a datasheet form, Access displays arrows on the right side of each column header. These arrows allow you to drop down a filter menu to filter the various columns, as seen in the following screenshot.
If you don't want to display these arrows, here's a quick workaround to disable them. Open the datasheet form in Design View and then open the Property Sheet for the form. Look for the property called Shortcut Menu on the Other or All tab of the Property Sheet. Change that property to No, save the form, and now switch back to Datasheet View. Access now removes the arrows from the top of the column headers, as seen in the following screenshot.
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page