I have a combo box with 3 fields; ID, ShortCode and Name. I have the columns set to 0;1;2.5 so only the ShortCode and Name are shown. What I want is for the user to be able to type in the short code but the combo box to display the name. Can this be done?

Not sure but you could put a text box next to it and show the name in there.

Thanks but I forgot to say that the form is in datasheet view.

The Text box would still work in datasheet view if you have the room for it.

Cheers, never thought of that. I'll give it a go and feedback.

Thanks Woody, With a bit of tinkering, I added an unbound text box into the form and set it to the column of the dropdown with the info I wanted (Edit)

[This message has been edited by Fizzio (edited 11-20-2001).]