>If I have a combo box with 2 columns, how can I get the value of column two to be displayed when the box is not dropped down.

-------------- Reply

Matthew:

Are you trying to display both columns when the combbox is not dropped? What about arranging your rowsource so that the strings in column 1 and column 2 are cancatated (sp?) into column 1, i.e.

SELECT;
    TRIM(a.column1var)+TRIM(a.column2var) ;
    FROM columsourcetable a ;
    INTO array aRowSource

instead of

SELECT;
     TRIM(a.column1var),;
     TRIM(a.column2var) ;
     FROM columnsourcetable a ;
     INTO array aRowSource

This will have the effect of assigning colum1+colum2 to your controlsource field, so you will have to play with refresh() and lostfocus() to ensure that only the column1 part of the .value gets back to your table.

I have not done it, but do not see why it cannot be done.

Regards,

JME