>>>Is there a way to display contents of a memo field in the combobox instead of the "Memo" display?
>>
>>Yes:
>>
>>Rowsource = alltrim(tablename.fieldname)
>
>Sorry. I wasn't specific enough. This memo field is the 2nd of 3 fields that needs to be displayed when dropdown appears. I could set RowSource = code+ALLTRIM(descript)+STR(amount,10,2) but the columns don't show lined up.
John,
The 2nd and 3rd columns don't show at all, or they don't show in the form you want them in?
There is no problem assigning a memo field as a column in a combobox. It will not display "memo", but the actual memo content.
Be sure columncount = 3 and that columnwidth for each column is adequate.
regards,
Jim Edgar
Jurix Data Corporation
jmedgar@yahoo.comNo trees were destroyed in sending this message. However, a large number of electrons were diverted from their ordinary activities and terribly inconvenienced.