Combobox visible columns when selected

[Extinct]

Hi,

I have a combobox with 3 colums 2 of which visible (width <> 0). The problem is that the 2nd visible column is only visible when the box is dropped down. When the value is selected the second visible column is not visible.

This is a problem because the box selects names with name and surname in different columns. Now I could modify the recordsource query so that the names are concatenated, but this doesn't seem to be an elegant solution.

 

[RoyVidar]

That's how they behave, and you've presented the usual workaround;-) There might perhaps be some list/combo tweaking things at Stephen Lebans or other places. Or - would a listbox control be more fitting?

Or, as is also used, have another text control (or more) and drop the other columns into that in the after update:

[tt]me!txtFname.value = me!mycombo.column(1)[/tt]

- to drop the second column into a text control (zero based)

Roy-Vidar