>>>>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.
"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."