<html><body><div style="font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000"><div>Hi all,<br></div><div><br></div><div>I am fighting with this memo output text on TDBLookupComboBox control.<br></div><div><br></div><div>I have this db query: SELECT (flute.flute || '-') || flute.description AS flute<br> FROM flute;<br></div><div>and there are some similar queries. In a TDBGrid, we can let the output as is as the query result and not the (MEMO) output by using the<br></div><div>TDBGrid's PrepareCanvas and the OnGetText events using this class:<br></div><div><br></div><div>MyMemoClass = class<br> public<br> procedure DBGridOnGetText(Sender: TField; var aText: string;<br> DisplayText: boolean);<br> end; </div><div>....<br></div><div>procedure MyMemoClass.DBGridOnGetText(Sender: TField; var aText: string;<br> DisplayText: boolean);<br>begin<br> if (DisplayText) then<br> aText := Sender.AsString;<br>end; </div><div><br></div><div>Then the final declaration at TDBGrid's PrepareCanvas event:<br><div><br></div></div><div>var<br> mGetExactString: MyMemoClass;</div><div>Begin<br></div><div> TDBGrid1.Columns.Items[x].Field.OnGetText := @mGetExactString.DBGridOnGetText;<br></div><div>end;<br></div><div><br></div><div>Is there a way I can do this similarly with TDBLookupComboBox control? I'm trying to find the similar PrepareCanvas and OnGetText events from TDBLookupComboBox but I find nothing...<br></div><div><br></div><div>Regards,<br></div><div>Allan<br></div><div><br></div></div></body></html>