Combo box - Show 3rd Column in resulting selection

C

Cydney

Hi. I have a combo box prepared like this:
Col1: Name (shown as "LastName, FirstName" --for proper sorting)
Col2: Supervisor
Col3: "FirstName LastName"

In my resulting combo box, I would like to show Col3, not Col1.
Can this be done?
--
Thank you, cs
~~~~~~~~~~~~~~~~~~~~~~~~
"What lies behind us and what lies before us are tiny matters compared to
what lies within us."
~ Ralph Waldo Emerson
 
M

Maurice

Sure set the columwidths to:

0,0,2 (or any width you like)
This will result in what you would like to see..

hth
 
J

John W. Vinson

Hi. I have a combo box prepared like this:
Col1: Name (shown as "LastName, FirstName" --for proper sorting)
Col2: Supervisor
Col3: "FirstName LastName"

In my resulting combo box, I would like to show Col3, not Col1.
Can this be done?

Set the ColumnWidths property to

0";0";1"

or whatever width you want for the col3.

It would help if you posted the SQL view of the actual rowsource query.
Normally in a combo like this I'd use a query such as

SELECT [Firstname] & " " & [LastName] AS FullName, [Supervisor]
FROM peopletable
ORDER BY LastName, FirstName;

On the other hand, having the names come out in a different order than the
visible column defeats the autocomplete feature - do you really want to see

Zelda Aarons
Bill Adams
George Anderson
Lisa Barnes

and be unable to just tab into the combo and start typing the name?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top