Combobox Columns Showing

  • Thread starter Thread starter Patrick G
  • Start date Start date
P

Patrick G

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

Can a combobox when it hasnt been clicked open?
 
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.
 
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?
 
Patrick said:
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?
Click to expand...

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."
 
Cause I didnt know I could do that :)
thanks
-----Original Message-----
Patrick said:
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?
Click to expand...

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.
.
Click to expand...
 
Back
Top