[AccessD] Filters in Datasheet View

[David Emerson]

Hi Listers,

 

Access 2010.  Access table back end.

 

I have a datasheet view of a form which shows the sort and filter dropdown
in the column headings.  I see the sort options, and standard filters (eg
Text filters for Equals, Does Not Equal, etc).  However, I don't see in the
list the options to select several items.  EG a countries field should have
a list of the countries in the data so that I can filter several at the same
time by checking boxes. 

 

I have simplified the data source so that it is only 1 table.

 

I have the same problem if I open any table directly.

 

Is there a setting or condition that has turned this off?

 

Regards

David Emerson
Dalyn Software Ltd
Wellington, New Zealand