Sort Pickilists

[Henro]

Can I sort picklists in alfabetical order? If so,

how??

Thanks for thinking!

Henro

 

[John Vinson]

Can I sort picklists in alfabetical order? If so,

Base the Listbox or Combo Box (there is no such thing as a "picklist"
control in Access) on a sorted Query.

 

[Henro]

Whatever I do, it keeps 'em sorting on the primary key (autonumber thingie)

 

[John Vinson]

Whatever I do, it keeps 'em sorting on the primary key (autonumber thingie)

Please describe in more detail. What are you using as a "picklist"? If
it's a Listbox or a Combo Box, what is the Row Source property? If
it's a table then it will be sorted in an unpredictable order
(sometimes by Primary Key, sometimes not). If it's a Query with a Sort
(Order By clause in SQL) then it will (not should, WILL) honor the
sort that you specify!