Problem with Alphabetizing

[AlfredNor]

Microsoft Access isnt alphabetizing when I use the A -Z ascending button. I click in my customer name field, then hit the button.

It works...but there are always a few stragglers...that is to say a P between D and E....or a Q between L and M.

Actually...it works with the actual records, but I have an unbound text box that Im using to scroll through records...and THAT is the list that wont alphabetize.

Am I doing something wrong?

Even more importantly...is there a way I can set that grp of fields (already the primary key) to automatically alphabetize any time that form/ table is opened? Like a property set at "Always alphabetize this form?"

Thanks.

 

[colmtourque]

I'm confused by your first problem but if you order the table based on a field the forms should follow
I.e. order in table on LastName and all forms based off this table should follow.

 

[AlfredNor]

strange

I went to the underlying table...and re-ordered the files based on a field (the Customer Name field)...but the unbound text box that I am using to scroll through the list of Customer Names...still has "stragglers."

Its really bothering me....I mean I know that people can start typing and get the name they want..but my boss just likes scrolling through and wonders whats wrong with me because the names wont alphabetize in a list that should be alphabetized.

The crazy thing is that the ACTUAL records in the master form ARE in the correct order...its just this list box that wont put them in the right order.

Is this a bug in MS Access>?

 

[ColinEssex]

A list box runs on an underlying query. Make sure you have the sort order set to "Ascending" in that query

Col

 

[AlfredNor]

I used the wizard

Ahh....I had never saved the Query under the box....I had made it with a wizard so it just ran from the table not a query.

Once I checked the properties and then hit the "..." on RowSource the SQLQuerybuilder came up and i made the sort ascending and saved it with a new name.

Now the list box behaves! No stragglers. Thanks for the info.
Thats a lesson for those making list boxes...always CHECK your properties when you use a wizard! (Im probably the only on on these boards that didnt know that ha ha ha)

Many kudos to the posters here.


Respectfully submitted,

Alfie