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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

combo box sort in my specified order 2
Alphabetical order in combo box 7
How to Navigate Through Records in Alphabetical Order 2
How to type each letter of the alphabet automatically in a specific color in Word? 0
Setup combo box Alphabetically 3
Combobox order problem 1
Order of records on a forn 3
Excel How to Auto-Alphabetize a Specific Range in Excel? 1

Back
Top