combox

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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,
 
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
 
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,
 
What are the values in the properties
1. ColumnWidths
2. ListWidth - Is it auto?

Check if the two fit
 
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
 
Yes, There is.
There are 2 fileds in the drop donw list, but only one field fills the drop
down box.
 
Back
Top