>>>>>>>>>Hi. I am trying to get a listbox to display fields 1,11,13 of a dbf that has 23 fields but it seems it takes them seq. by default even though I have field1,field11,field13 listed in the rowsource.
>>>>>>>>
>>>>>>>>Can you tell us what are ListBox.RowSource, RowSourceType and ColumnCount properties?
>>>>>>>
>>>>>>>rowsource is lname,ss_num, dob
>>>>>>>rowsourcetype is alias
>>>>>>>columncount=3
>>>>>>
>>>>>>Rowsourcetype should be 'fields'. Rowsource should include alias, e.g. "table1.lname,ss_num,dob"
>>>>>
>>>>>OK. Thing now is that the cols are not comfortably wide enough to house the chosen fields entirely.
>>>>
>>>>So, make your list wider, or even use grid.
>>>
>>>In the properties section I was able to now. Last quest(for a while)
>>>Can you choose a certain color for a certain listbox column?
>>
>>I don't think so, because List's column is not an object.
>
>Sounds like you really need to be using a grid.
But I want list items clickable.
"Build a man a fire, and he's warm for a day.
Set a man on fire, and he's warm for the rest of his life."