Set the "Auto Expand" property to true for the combobox.

As far as sorting, work in a form, not the table, and you will be able to
control the sorting

--
Rick B



"microsoft" wrote in message
...
Hi

Database: Symbols
Database is filled with data from apple to zebra - therefore using every
letter in the alphabet.

Is it possible in Access, that when a user selects a combox box and they
type the first letter in a word e.g "p" that the combo box scrolls to the
first word beginning with p. I hope i have explained this clearly.

Also is it possible that when a user adds data to a database it is
automatically sorted in ascending order.

Thanks