[AccessD] Filters in Datasheet View

[David Emerson]

Found the answer.  In the options for the Current database is a filter
option "Don't display records when more than this number is read".  It was
set to 0 (I thought this means no limit).  I changed it to 1000 and the
selection lists appeared.

Regards

David

-----Original Message-----
From: AccessD [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of
Charlotte Foust
Sent: Thursday, 20 September 2018 8:05 p.m.
To: Access Developers discussion and problem
Subject: Re: [AccessD] Filters in Datasheet View

You have to use a query for that.  It is outside the capabilities of a
filter.

On Wed, Sep 19, 2018, 7:22 PM David Emerson <newsgrps at dalyn.co.nz> wrote:

> 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