combox

S

Souris

I have a combo box to link Employee ID from my foreign key table.
In my primary key (Employee) table has first name and last name fields.
I wanted to my combo box to show 2 fileds like First Name + Last Name, but
it only shows one columns only.

Is it possible to show 2 columns from my primary table?
Any informaiton is great appreciated,
 
O

Ofer

Check the following properties of the combo box, If any of them correct move
to the next one
1. Does the RowSource of the combo includes both fields
2. Does the ColumnCount Property is 2, and not 1
3. Is the ColumnWidths include enough width for both fields, and it not to
wide to fit in the combo size
e.g 3 cm;4 cm
 
S

Souris

Thanks for the message,
1. Yes, it includes 3 fields
2. Yes, columncount = 3
3. Yes, it has enough length to fit 2 fields

I still do not get 2 columns.

Anything I can look more?
Thanks m,illions,
 
O

Ofer

What are the values in the properties
1. ColumnWidths
2. ListWidth - Is it auto?

Check if the two fit
 
O

Ofer

Also check if you have a scroll bar on the buttom of the list to move to the
next record, which mean its not wide enough
 
S

souris

Yes, There is.
There are 2 fileds in the drop donw list, but only one field fills the drop
down box.
 
Top