Combo when non-drop down display issue

[cath_hopes]

Hello!

I've used unbound combos on several of my forms and am wondering how to get them to display their multiple column values (either default or selected) fully.
When a user clicks on the drop down arrow of a combo, all columns (aside from the hidden one) are displayed apart from the main combo field itself which only shows a value from the first column.
How can I get all columns to display in this main field whether a user has clicked this field or not?
I hope I have explained this clearly enough.

Thanks in advance.

 

[boblarson]

Use a list box then. A combo will ONLY display one column after selection.

 

[cath_hopes]

Yes a list box is a solution - the combo just looks better. Thanks for your help all the same.

Catherine

 

[boblarson]

Yes a list box is a solution - the combo just looks better. Thanks for your help all the same.

Catherine

Each one has different features that the other doesn't have. A combo can only display one column of selected data at a time. A list box can show multiple columns. A list box can be multi-select whereas a combo can only select one value. Of course a combo takes up less space than a list box.

You could, however, look for a third party solution (ActiveX control) that might be available to do what you want, but it would probably cost some money and it would need to be on all of the computers that are going to use your database.

 

[cath_hopes]

Interesting about ActiveX route, I wonder whether Microsoft, as part of a future Access release, might get the combo to display more than one column. Anyway, I'm going to stick with the combos for the time being.
Would you know how I could reset a combo to just display blank as it does when a form initially loads? I tried combo.requery just updates the list without removing the selection.

 

[missinglinq]

One workaround, assuming your form is based on a query, as it should be, is to create a calculated field that concatenates the fields you want displayed, then base your combobox on this calculated field. In the Design Grid for your query, in a blank field box enter something like this:

FullNameAndAge: [LastName] & " " & [FirstName] & " " & [Age]
Now, when you create your combobox, select the field FullNameAndAge as the first field.

When you use your combobox the display will be like

Adamson Linq 58
Lyons Mitzi 45
Poe Edgar 198

Linq

 

[ShaneMan]

Would you know how I could reset a combo to just display blank as it does when a form initially loads? I tried combo.requery just updates the list without removing the selection.

Hey Cath,

Me.ComboName = ""

Should get what you want accomplished.

HTH,
Shane

 

[cath_hopes]

Thanks Shane, my combos now reset to blank fine!

 

[ShaneMan]

Thanks Shane, my combos now reset to blank fine!

Your welcome. Glad I could help.

Shane