<div>
My first thought would be to make sure there are values available in the column you are trying to sort by. &nbsp;Since its just a collection of fields used in the column, (not all the possibilities, unless you are querying an entire table) &nbsp;I would presume it means those are just null, or empty of some sort.<br />
<br />
Beyond that I'm not to sure. &nbsp;Could you post a screen shot of it?<br />
(Jing is a good screen shot tool)
</div>


My first thought would be to make sure there are values available in the column you are trying to sort by.  Since its just a collection of fields used in the column, (not all the possibilities, unless you are querying an entire table)  I would presume it means those are just null, or empty of some sort.

Beyond that I'm not to sure.  Could you post a screen shot of it?
(Jing is a good screen shot tool)

<div>
Screen shot examples posted/attached.<br />
<br />
<br />
<br />
<a href="https://filedb.experts-exchange.com/incoming/2012/09_w37/602996/non-working-example.bmp" target="_blank" title="Non Working Example (423 KB)"><img alt="Non Working Example" class="file-block lazyload" style="max-width: 312px;" data-src="https://filedb.experts-exchange.com/incoming/2012/09_w37/602996/non-working-example.bmp" /></a><br />
<a href="https://filedb.experts-exchange.com/incoming/2012/09_w37/602997/Working-Example.bmp" target="_blank" title="Working Example (200 KB)"><img alt="Working Example" class="file-block lazyload" style="max-width: 299px;" data-src="https://filedb.experts-exchange.com/incoming/2012/09_w37/602997/Working-Example.bmp" /></a>
</div>


Screen shot examples posted/attached.



Non Working Examplehttps://filedb.experts-exchange.com/incoming/2012/09_w37/602996/non-working-example.bmp
Working Examplehttps://filedb.experts-exchange.com/incoming/2012/09_w37/602997/Working-Example.bmp

non-working-example.bmp

Working-Example.bmp

<div>
So on the first one, is there anything aside from &quot;Test Scenario 5&quot;? &nbsp;I'm guessing if there is only 1 value, it might not offer field selection, though that seems weird because why would it offer you sorting, if it chose to remove other similar options in that case.<br />
<br />
Perhaps that is it. &nbsp;Aside from that, I'm not too sure.
</div>


So on the first one, is there anything aside from "Test Scenario 5"?  I'm guessing if there is only 1 value, it might not offer field selection, though that seems weird because why would it offer you sorting, if it chose to remove other similar options in that case.

Perhaps that is it.  Aside from that, I'm not too sure.

<div>
There's 17 different test scenarios in that field
</div>


There's 17 different test scenarios in that field

<div>
In both examples they are text fields limited to 255 character.
</div>


In both examples they are text fields limited to 255 character.

<div>
<div class="content wysiwyg-content">
On some of my forms in my access application, if I select a form field and then select the filter button on the toolbar &nbsp;the possilbe values are not shown. &nbsp;What causes this?
</div>
</div>


On some of my forms in my access application, if I select a form field and then select the filter button on the toolbar  the possilbe values are not shown.  What causes this?

Filter by Selection: Possible Values Not Showing

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.