combo boxes

[john]

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

thanks in advance

 

[Guest]

Open the properties on your combo box. In the Row Source property, open the query builder and sort by which ever variable you want.

 

[John Vinson]

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

thanks in advance

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.

 

[john]

thanks for that i never thaught of doing it that way, and so simple