Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Memo field in combo box
Message
From
26/07/2000 11:06:29
David Fluker
NGIT - Centers For Disease Control
Decatur, Georgia, United States
 
 
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
00396895
Message ID:
00397072
Views:
11
>>>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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform