Access MVP (2010-2015)

oOo.oOo.oOo.oOo.oOo.oOo

Turn off Datasheet Subform filtering

Tip provided by Don Leverton

Beginning¬†with Access 2007 …

Datasheet style subforms (which I use a LOT of) have been “improved” by offering dropdowns in the top row of fieldnames, which allow filtering and sorting options.

DatasheetView

This is something that I DO NOT want!

In order to turn OFF this behavior, go to the individual subform’s Design View, and open the form’s Property Sheet.

Scroll down to the “Shortcut Menu” and set it to “No”.

Reopen your datasheet subform, and voila!

DatasheetViewNoFilter

Save the form and that’s it.

2,657 total views, 5 views today

Comments are closed.