>>Is it possible to create a two column combo box where both columns are
>>based on the same field. The first column is the last 8 characters and
>>the second column is the full field. For search purposes the last 8
>>characters are used in an index, but it is not necessarily a unique value
>>so the full field must also be veiwed.
> What if you try to create a cursor with two fields, meeting your
>requirements and use it as RowSource for your combobox?
>L< answered this one on the microsoft.public groups. She was able to get it to work programatically, by setting the RowSourceType to 6 and the RowSource as follows:
cboWeird.RowSource = ("right(field, 8), field")
I haven't tested this myself, so I can't vouch for its workability....