>I have a combobox set up for rowsourcetype = fields and rowsource=tablename.field1,field2
>
>When the user selects something from the text box, both fields show up great. When the text box closes, only field1 continues to show.
>
>Is there a way to get both fields to continue to show in the displayvalue.
>(I can add the two fields together to accomplish this - but that makes the valids nasty and with proprortional fonts they don't line up well!)
>
>first element is 1 and column count is 2
>
>Thanks
>Donna
No, only first column goes to displayvalue. You could use SQL rowsource to add the displayvalue combination you want. With a SQL rowsource you would have the all columns reachable. ie:
with this
.RowSourceType=3
.Rowsource = 'select First_Name-(" "+Last_Name) as pname, '+;
' First_Name as fname, last_name as Lname, *'+;
' from employee into cursor crsEmployee'
.Columncount = 3
.Columnwidths = '0,100,100'
endwith
In valid check myCursor.Fieldname not value (though you might).
Cetin