Want a combo box to display multiple columns after user chooses

[Guest]

All,

I am currently creating a form that contains a combo box that when clicked
will allow the user to select a training program. The Training Programs table
has and ID, ProgramTitle, and ProgramDate. The user knows the training
program by it's title and date combined. I am doing fine in that when they
click the combo box, it shows both the title and date, but once they select
the proper entry, and the combo box closes the list, only the title is
visible, and not the date.

Can anyone suggest a simple way to make both display once the list is
collapsed?

Any and all help is appreciated.

Dan

 

[Guest]

Open the form in design view. Click on menu VIEW - Properties. Change the
Column Widths from something like this ---
0";1";0"
to like this ---
0";1";1.5"
based on the space needed to display the columns.

 

[fredg]

All,

I am currently creating a form that contains a combo box that when clicked
will allow the user to select a training program. The Training Programs table
has and ID, ProgramTitle, and ProgramDate. The user knows the training
program by it's title and date combined. I am doing fine in that when they
click the combo box, it shows both the title and date, but once they select
the proper entry, and the combo box closes the list, only the title is
visible, and not the date.

Can anyone suggest a simple way to make both display once the list is
collapsed?

Any and all help is appreciated.

Dan

A combo box will only display one column after a selection has been
made (the first column whose width is greater than Zero inches).

 

[Bob Quintal]

Thanks Fred, is there any way around this? It will really confuse
the user if they don't see the concatenated information.

Yes, put an unbound textbox next to the combobox, and set its
controlsource to the name of the combobox and the zero-based column
number (eg the first column is 0)

= [comboboxmame].column(n)

Q

 

[Guest]

Thanks Fred, is there any way around this? It will really confuse the user
if they don't see the concatenated information.

 

[Joan Wild]

Yes there is. I assume the rowsource of the combo is set to the Training Programs table. Change the rowsource to
SELECT [ID], [ProgramTitle] & "-" & [ProgramDate] FROM [Training Programs];

Bound column: 1
Column widths: 0",2" (or whatever's suitable)