Field values in Alphabetical order

  • Thread starter Thread starter Sok Hong
  • Start date Start date
S

Sok Hong

Do any of you know how to set the combo box so that the
selection are shown in alphabetical order? Thank you.
 
-----Original Message-----
Do any of you know how to set the combo box so that the
selection are shown in alphabetical order? Thank you.
.
Click to expand...

To sort the contents of the combo box;

from the combo box's property window, click on the Data
tab, then select the row source, in the query screen you
can select the sorting order for the desired selection.
 
Hi
Simply set your Rowsource as follows:

SELECT <FieldNAme> FROM <TableNAme> ORDER BY <FieldName>

MAurice
 
Back
Top