combo boxes

  • Thread starter Thread starter john
  • Start date Start date
J

john

is there a way to force the combo boxes to display theier data in
alphabetical order?

thanks in advance
 
Open the properties on your combo box. In the Row Source property, open the query builder and sort by which ever variable you want.
 
is there a way to force the combo boxes to display theier data in
alphabetical order?

thanks in advance
Click to expand...

Certainly; base them on a Query sorted by the field you want in
alphabetical order. If it's an existing combo, view its properties in
form design mode; click on the ... icon by the Row Source property. A
query design grid will open. Specify Ascending on the sort order for
the desired field and close the query window, and accept Access' offer
to save the SQL.
 
Back
Top