Sort Pickilists

  • Thread starter Thread starter Henro
  • Start date Start date
Can I sort picklists in alfabetical order? If so,
Click to expand...

Base the Listbox or Combo Box (there is no such thing as a "picklist"
control in Access) on a sorted Query.
 
Whatever I do, it keeps 'em sorting on the primary key (autonumber thingie)
Click to expand...

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!
 
Back
Top