Combobox Columns Showing

[Patrick G]

A list box can show more then one column at a time.

Can a combobox when it hasnt been clicked open?

 

[PC Datasheet]

The drop-down list of a combobox can be any number of columns. Just set the
ColumnCount property to the number of columns you want and the ColumnWidths
property of each column appropriately. However, after you select a row in the
drop-down list, you will only see the value in the first column that has a
column width greater than .008.

 

[Patrick Graham]

Does anyone know a work around so that the first and last
name of a person selected in the combo box would be
displayed?

I concidered overlaying a lbl modified to look like a
combobox and changing its caption to reflect the choice
made. This the best approach?

 

[fredg]

Does anyone know a work around so that the first and last
name of a person selected in the combo box would be
displayed?

I concidered overlaying a lbl modified to look like a
combobox and changing its caption to reflect the choice
made. This the best approach?

Why not just change the rowsource of the Combo box from
"Select [NameID],[LastName],[FirstName] From ... etc."
to
"Select [NameID],[LastName] & ", " & [FirstName] as FullName From ...
etc."

 

[Pat G]

Cause I didnt know I could do that
thanks

-----Original Message-----

Does anyone know a work around so that the first and last
name of a person selected in the combo box would be
displayed?

I concidered overlaying a lbl modified to look like a
combobox and changing its caption to reflect the choice
made. This the best approach?

Why not just change the rowsource of the Combo box from
"Select [NameID],[LastName],[FirstName] From ... etc."
to
"Select [NameID],[LastName] & ", " & [FirstName] as FullName From ...
etc."


--
Fred
Please reply only to this newsgroup.
I do not respond to personal e-mail.
.