How to display "row source" in combo box in alphabetical order

[fulltime]

Hi all,

I am using a combo box in my form and its row source is set to Table A, however, the data in the combo box arent displayed in alphabetical order even though the data from Table A is sorted in ascending order.

can pls help me by teaching me How to display "row source" in combo box in alphabetical order??

thks alot

FT

 

[MStef]

In QUERY BUILDER put Sort: Ascending or Descending.

 

[Rod D]

You have lots of options here...

Hi FT

Access stores data in tables in the most efficient way that it can - rarely is it in the way we would like to see it. When viewing the data, sort orders are applied "in the background" so would appear to be sorted, but actually are not.

To fix your problem, the two simplest methods are:

One
Build a query to select the fields you want and apply the sort order there.
Set the combobox Row Source Type to "Table/Query"
Set the combobox Row Source to the name of the query.

Two
Set the combobox Row Source Type to "Table/Query"
Clear the Row Source and build an SQL statement by clicking the [...] button at the end of the field. You can set sort orders there as well.

You can do this via VB as well, but I don't see the point.

HTH
Rod

 

[fulltime]

thks Mstef and Rod D for ur replies.. it works fine