Combo Boxes

[microsoft]

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

 

[Rick B]

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

 

[microsoft]

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]

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.

 

[microsoft]

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]

Then adjust the record source of your combo box. Your row source is a
table/query. Make it a query and set a sort order.

 

[NWO]

Do you know how to sort records via the form so that the records show as you
like?

A combo box has an asscoiated query where you can limit how the dtaa is
displayed via the Combno Box.

NWO.

 

[Jen]

I'm having the same problem with sorting. I went into the form and changed
the row source in properties...from "table/query" to "query", as Rick
suggested. How do I set a sort order?

When I changed the row source to query and opened the form, it no longer
gave me the list. The arrow still showed up, but the box was just empty.

I'm new to creating databases, and am in a position where I have to learn as
I go...so any help is much appreciated.

 

[Bob Miller]

In the query sort the field that contains "apples" to "zebra" in
ascending order. When you type a "p" in the combo and you have
"peach", "pet", and "pie", "peach" will pop up. If you continue typing
"i", "pie" will show. If you have a lot of items that begin with the
same first say three letters, they will be in order if you use the
dropdown arrow on the combobox and you shouldn't have to scroll too
far.
To me, it is too complicated and hit and miss to try to sort in a form.
It should take only a couple of minutes to create a query and then
insert a combo based on that query in the form.