Multi Column Listbox

[xiong]

Has anyone every come across a way to make a listbox, combobox, or subform show multiple columns. Ideally, I'm looking for a list box that displays my data like this:

Key | LName || Key | LName
122 | Johnson || 126 | Evans
123 | Hunter || 127 | Barrow
124 | Smith || 128 | Childs
125 | Davis || 129 | James

Users will still only be selecting one record (eg. 128-Childs)



"Only the educated are free.

 

[dhookom]

List boxes properties can be set to display multiple columns. A combo box can also display multiple columns when dropped down.

Check the Column Count and Column Widths properties.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[willir]

...and the RowSource SELECT statement where the number of columns in the SELECT statement must match the ColumnCount

 

[xiong]

Yes, but the number of columns directly corresponds to the number of fields outputed. I'm looking to turn 2 fields into 4 columns.


"Only the educated are free.

 

[traingamer]

As far as I know, it cannot be done.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill