All field not showing from query

[cafulford]

Hi, I have a combobox that I have set the following query to in the RowSource property and when run, I only get the 1st field (prod_id_2) to display. I can not figure out why it is not displaying the other 2 fields.

select prod_id_2,prod_desc,size from sw_prod order by sw_prod.prod_id_2

I ran the query directly from Project Manager/Query and all 3 fields are there and look perfect.

I am not a VFP 6 programmer but I am trying to figure this out.

Thanks in advance,

Charlie

 

[Nigel Gomm]

Charlie,

set the columncount property on the combobox to 3

nigel

 

[Olaf Doschke]

By design, a combobox will only show the first field it's list is not dropped down. Always, no matter how you set ColumnCount and ColumnWidths.

But these two help to setup how the dropped down list looks like. You better put fields in the order you want them.

You could also set ColumnCount to one more column than you really need and set the width of the first column to 0, then concatenate values of the following columns in column one.

For example:

Showing last name and first name in three columns: 0,100,100 with first column being last name +','+ first name, second column being last name, third column being first name and setting columncount to 3 you see last name column seperator line and first name, when the combo list is dropped down and last name, first name, after selecting a person.

Bye, Olaf.

 

[cafulford]

Thanks so much Nigel and Olaf. Much appreciated!

Charlie