RitaGale
07-27-2000, 05:14 PM
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!!
R. Hicks
07-27-2000, 05:36 PM
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
RitaGale
07-27-2000, 06:23 PM
Thanks Rick!!! That worked GREAT!
RitaGale
07-27-2000, 06:24 PM
Thanks R!!! That worked GREAT!