>>Question.. I have 3 tables I am putting into 3 dif. comboboxes.. they all have memo fields in the tables. Unfortunately, the data in the memo fields is what I need displayed in the dropdown combobox. when I just select it in properties for rowsource = 6 the combobox listing just says "memo" and not the actual info in the memo. Anyway I can set it up so that the combobox will list the information in the memo field?
>>
>>TIA
>
>Robert,
>
>You could perform some string functions to get the value of the memo field into a combo, but the better way might be to use a combination of edit boxes and combos. Combos to select and the edit boxes to display the memo fields.
>
>Regards, Renoir
I like this idea. You can show, say, 30 first chars of Memo in a combo and show the whole Memo in EditBox near this combo. You can create a container class for this functionality, which is very simple to implement (just use Combo.InteractiveChange to refresh the EditBox)
If it's not broken, fix it until it is.
My Blog