[garen]

In Access 2003, have a form that I am viewing in Database-view as the default with a few combo boxes menus. Each of these combo boxes has two columns that display when you drop then down to make a selection, however, when you choose a selection, only the value of first colum is displayed in the "unopened" combo box. Is there a way to have all the columns' values displayed when the combo box is "unopen"?
Thank you!

[OBP]

Hello garen and welcome to TSG, no I am afraid there isn't a direct way to display all of the columns once a selection has been made. If the first column is an ID number and therefore not very meaningful it is better to set it's Column width to 0cm. Only the second column will be visible then.
If you want to display the data from more than one "Field" (column) of your table in the combo you have to "Concatenate" the fields in to a new column in the Combo's SQL (Query) and display that single column instead of all the other columns.
For instance
Field 1 - First Name - data = "Fred"
Field 2 - Surname (or Last name) data = "Bloggs"
create a new Column Heading and type in

fullname: [First Name] & " " & [Surname]

the result displayed is
Fred Bloggs

You can "Concatenate" as many fields as you like using the & character to add them to each other. The " " just makes a space between them to make them readable, you could use " - " or ", " etc

[Ziggy1]

If I could suggest also...

You can add a text control and refer to the column, just experiment by changing the number...

Put this in the control source of the text box ( changing to match your object names of course)

=Forms!YourFormName!ComboName.column(2)

[garen]

OBP, thanks a lot... I tried the Concatenate method and it is working great. Thank you!