Access Subform Filter Unavailable

CFrasnelly
CFrasnelly used Ask the Experts™
on
Does anyone know why I am unable to filter on a bit field type in Access????  See the attached screenshot.  All the other fields will let me filter as normal but Filters menu item is noticeably missing for this field.

Access 2007 .adp project

Thanks!
FilterIssue.jpg
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
MIS Liason
Most Valuable Expert 2012
Commented:
You are clicking in the wrong spot if you want this to work.
(Clicking on the column heading won't allow filtering on any field)

See the screenshot:

;-)

JeffCoachman

untitled.JPG

Commented:
check the allow filters properties and set it to yes

Author

Commented:
I can't believe MS won't let you filter by clicking the filter arrow... sheesh... thanks!
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Thanks!
;-)

<I can't believe MS won't let you filter by clicking the filter arrow... sheesh... thanks!>
    That's because that is a "Sort Direction" arrow, ...not a Filter arrow...
;-)

Jeff

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial