You cannot display more than one field in the text box portion of the combo
box. The only time it's possible to display more than one column is when the
list is dropped down.

To control the order of the records in the combo box, base the combo box on
a query that has the appropriate ORDER BY clause. To change the order,
change which query you're using as the RowSource property. This can be done
in code.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
(no e-mails, please!)

"TheScullster" wrote in message
. uk...
Hi all

Just trying to get my head round these combo boxes!
I seem to have got the hang of controlling the record display when the
down arrow is clicked.
Managed to get correct columns visible with captions etc.
How do I vary the fields displayed when the combo box is inactive.
Once a selection has been made and the user has left the combo box, I
would like to display more than one field.

Also, is it possible to sort the display order of the records by user
selection.
I would like the user to be able to re-order the combo box by either of
two fields prior to a selection being made.

Thanks

Phil