I have a combo box on a form that i just can't seem to get to appear in an a-z format. Does anyone know how.

Many thanks in anticipation,

Rob

Are the values in your combo box based on a query or values that you've typed in? If it's a query then just adjust the sort order of the query to reflect the column that you want to a-z. If its values that you've entered yourself then you're a bit stuck. If its only a few rows then you're better off retyping it in. Good Luck :-)

Make the recordsource of your combo box a query which has the column which is displayed soreted appropriately.

You have an SQL statement as the row source for the combo box.At the end of the statement put this: ORDER BY [TableName].[FieldName] using the field that you want sorted.