I have a two column comobox (FirstName & LastName) on a form. When I open the form and select this I only see the FirstName until I click the arrow. I would like to see both names. In the help file there is a note at the bottom that states: "Note: If you want to display all the columns in a multiple-column list box (instead of scrolling horizonally to find them) size the control to fit the columns widths." I understand the difference from list and combo boxes, but this is the note that was at the bottom of help on a multi-column combo box. Each property size is 45 in the table. ColumnWidths property is 1";1". HELP!!
Multi-column combo box
- Thread starter RitaGale
- Start date
R. Hicks
AWF VIP
- Local time
- Today, 04:58
- Joined
- Dec 23, 1999
- Messages
- 618
In the property list for the combobox, set the Column Count to 2. The default is 1.
Another idea would be to concatenate the two names together in a third column. To do this set the column count described above to 3. Then add an expression to the Row Source query:
FullName:[FirstName] & " " & [LastName]
This will put the two names together seperated by a space, together in on column.
Set the column widths to: 0";0";2"
This will hide the first two columns. You then need to set the Bound Column to the column of your choice.
HTH
RDH
Another idea would be to concatenate the two names together in a third column. To do this set the column count described above to 3. Then add an expression to the Row Source query:
FullName:[FirstName] & " " & [LastName]
This will put the two names together seperated by a space, together in on column.
Set the column widths to: 0";0";2"
This will hide the first two columns. You then need to set the Bound Column to the column of your choice.
HTH
RDH
Similar threads
