Share via

MS Access Filtering/Sort Problems 2013

Anonymous
2014-05-21T10:03:40+00:00

I was running Access 2010 and experienced a problem with the Sort filter icon being greyed out on one field only, within one form

It happened suddenly and I haven’t been able to trace why; whether it was because of a Windows Access update or finger trouble…………..

I have Googled for the obvious, and ruled out a variety of things, as I have.........

  • Cleared All Filters and re-applied
  • Checked no-one has saved a filter
  • Checked use of underscores and reserved words, spaces in Field names, multiple fields with same names = none
  • Checked all Access patches applied

I’ve run a repair on Access – no success

Finally, I have just upgraded to Access 2013 and the problem still exists 

Could you help please?

Ian

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

11 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-05-21T16:36:53+00:00

    Hi

    Sorry it took me a bit of time, I was asking someone else to do the screen shot over the phone

    There is one attached but unfortunately without any data (although the view is still  the same)

    1.

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  2. ScottGem 68,830 Reputation points Volunteer Moderator
    2014-05-21T11:49:37+00:00

    Can you show us a screen shot?

    Was this answer helpful?

    2 people found this answer helpful.
    0 comments
  3. ScottGem 68,830 Reputation points Volunteer Moderator
    2014-05-23T11:59:04+00:00

    Open the table in Design mode and check the datatype. I'm suspecting it may be a Memo datatype. I just tested this and the memo datatype does not allow sorting.

    Was this answer helpful?

    0 comments
  4. Anonymous
    2014-05-23T09:57:59+00:00

    Hi Scott

    Yes it displays the same with data (Sort options greyed out)

    It is only the "Details" column - the others display the sort options

    I'm not a Database programmer, but the datafield is Alphanumeric/free format - do you need further information?

    Ian

    Was this answer helpful?

    0 comments
  5. ScottGem 68,830 Reputation points Volunteer Moderator
    2014-05-21T16:47:46+00:00

    And you say it displays the same way even if there is data there? This is on the Details Field, correct? What is the datatype for that field?

    Was this answer helpful?

    0 comments