Share via

Datasheet View Form - Drop down of Sort And Filter issue

Anonymous
2021-04-16T17:58:12+00:00

I have made a datasheet view form. 

When click on a text field drop down to filter or sort, the box contain option select All and others to be selected.

But when click to another text box drop down to filter or sort, the box does not contain this particular option - its missing

Could not understand my mistake, I have attached both the screen shot to make better understand.

Please correct my mistake, so that both can have SelectAll/Blank etc option type

Please advise

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

DBG 11,711 Reputation points Volunteer Moderator
2021-04-17T14:53:31+00:00

Hi. I don't think you can force the checkbox to show up all the time. I think Access looks at all the data in the field and makes a decision, based on some internal rules or logic, to show the checkbox or not. 

Again, it's not your fault. It's just how Access work. 

Sir,

Thanking you and thanking to Mr. Scottgem as well, for your advise. 

While exploring and testing a lot, found a solution, which I want to confirm "If I am doing ok ?., or it will have a bad side effect later globally on database - As I have disturbed the global setting and achieved the requirement". Worried !!. ... as lot of combo box and listbox has been used in several forms in this database. Will this change will harm the appearance of the other combo or listbox in the database - accde.

The actual setting limit was 1000, found my data was 6782 records. So changed to 10,000 and it worked for all fields. the drop down list appears. I have attached the screen shot, for your and Mr. Scott kind review.

Also to be noted : It has to be done at the front End - (will not work if done on back End.)

Kindly review and advise me on this, if I am correct going.

Image

Hi. I don't think that would hurt anything except maybe it would annoy your users having to scroll through 10,000 rows of data to find what they're looking for. Good luck!

Was this answer helpful?

1 person found this answer helpful.
0 comments

5 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. ScottGem 68,830 Reputation points Volunteer Moderator
    2021-04-17T00:34:03+00:00

    Finding it strange on "access determines", As both the field has data, both is text field.  Then How access is differentiating in between these two fields. And displaying checkbox for one and not for another

    Any idea, so that always it will display the check box as a must.

    Regards

    Access doesn't reveal the algorithm it uses to determine whether to display a list or not. If there is no list you can still use the Text filters to filter a record. What you can't do is always make it display a list.

    Was this answer helpful?

    0 comments
  2. DBG 11,711 Reputation points Volunteer Moderator
    2021-04-16T18:20:33+00:00

    Hi. I don't think you can force the checkbox to show up all the time. I think Access looks at all the data in the field and makes a decision, based on some internal rules or logic, to show the checkbox or not. 

    Again, it's not your fault. It's just how Access work.

    Was this answer helpful?

    0 comments
  3. Anonymous
    2021-04-16T18:11:54+00:00

    There was no mistake on your part. Access determines whether to display a list with checkbox or not depending on the amount and type of data. 

    Sir,

    Finding it strange on "access determines", As both the field has data, both is text field.  Then How access is differentiating in between these two fields. And displaying checkbox for one and not for another

    Any idea, so that always it will display the check box as a must.

    Regards

    Was this answer helpful?

    0 comments
  4. DBG 11,711 Reputation points Volunteer Moderator
    2021-04-16T18:07:33+00:00

    There was no mistake on your part. Access determines whether to display a list with checkbox or not depending on the amount and type of data.

    Was this answer helpful?

    0 comments