>>>i have a form with a comboxbox and a grid. my combobox has 3 columns as follows:-
>>>custid (Character 10)
>>>custname (Character 30)
>>>comments (Memofield)
>>>the data of which when selected, are to be transferred to a 3 column Grid respectively. i put the following code in the combobox's interactive method:-
>>>with thisform
>>>.grid1.column1.text1.value=this.list(this.listindex,1)
>>>thisform.grid1.column2.text1.value=this.list(this.listindex,2)
>>>thisform.grid1.column3.text1.value=this.list(this.listindex,3)
>>>thisform.refresh
>>>
>>>the grid's column1 and 2 are fine but all i get in column3 is the word Memo but not its data. please show me how to transfer the data to column3. tks
>>
>>You need to change the control in column3 from a text box to an editbox. Textboxes always show "Memo" for memo fields. Check knowledgebase article "Q127880 - How to View Memo Fields as Edit Boxes in a Grid" for instructions.
>>
>THe problem is not with the grid as I read it, he's trying to make the third column of the combobox a memo, and AFAIK, that's not supported at all.
Hmmm. II know of no direct way to display a memo field in a combobox either, but you can show part of a memo field if you populate the combobox with an SQL statement.
SELECT CustID, CustName, PADR(ALLTRIM(Comments),15) FROM TheTable ...
Of course you change the 15 to the number of characters you want to display in the combobox.
David.