help with combo box display...plz...

[ai_enjoi]

i have a multicolumn combo box...with columns FName, MName, and LName...how
can i enable it to display the 3 values of the column when a row is selected??
it's like that i'm merging the 3 values int the text box display of the combo
box...please....thank yu

 

[fredg]

i have a multicolumn combo box...with columns FName, MName, and LName...how
can i enable it to display the 3 values of the column when a row is selected??
it's like that i'm merging the 3 values int the text box display of the combo
box...please....thank yu

A combo box, after you have selected a row, will only display the
first column whose column width property is grater than 0".

If you need to see the 3 columns, you can concatenate the 3 columns
into one.

Select YourTable.[FName] & (" " + YourTable.[MName]) & " " &
YourTable.[LName] From YourTable Order By YourTable.[LName],
YourTable.[FName];

 

[ai_enjoi via AccessMonster.com]

thank you...it helped...i just added an ID for each person...tnx

i have a multicolumn combo box...with columns FName, MName, and LName...how
can i enable it to display the 3 values of the column when a row is selected??
it's like that i'm merging the 3 values int the text box display of the combo
box...please....thank yu

A combo box, after you have selected a row, will only display the
first column whose column width property is grater than 0".

If you need to see the 3 columns, you can concatenate the 3 columns
into one.

Select YourTable.[FName] & (" " + YourTable.[MName]) & " " &
YourTable.[LName] From YourTable Order By YourTable.[LName],
YourTable.[FName];