Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Field in table will not filter - info update

Field in table will not filter - info update

Field in table will not filter - info update

Back in 2014, in thread181-1725878: Field in table will not filter, "allendan" raised the issue of filtering not being available when viewing a table.
He ultimately noted the option default of "... 1000 max unique entries" had been applied to that field and so the checkbox list was not built.

Now the following statement relates to Access 2019 and is placed here to provide a further related information for this problem.

I just had a similar problem in one of the numeric columns in a table but as well as no checkboxes, I didn't get the "Number Filters" option either. Other numeric columns were ok.
Sure enough, when I changed the options setting to allow for 20,000 max unique entries, I got a checkbox list but still didn't have the "Number Filters" option.

I checked the definition of that column and it was of "Large Number" type. I changed the type to "Number" and the "Number Filters" option reappeared.
(Footnote: data analysis showed that a "Number" type field was more than large enough for the requirements)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close