Granted, I understand what you are saying, however when my user adds a new
record via the form interface. When the user goes to the combo box the data
entered is shown as the last in the combo and is not placed in its
alphabetical order. Is it possible to have the data entered into the system
and placed /sorted to its correct location in the database.

"Rick B" wrote:

Tables are simply buckets that store your records. They have no explicit
sort order. They are not intended to be used as a user interface.

When you add/change/delete records, you should be doing so in a form, not in
the table.

Once your database is created, you should rarely open your tables again.

--
Rick B



"microsoft" wrote in message
...
The autoexpand field is already set to Yes and I still am not achieving
this
goal. Please explain the last comment where you inidicated that I should
work in a form not the table to control the sorting.

"Rick B" wrote:

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