The Cleaner

how do you add items to a list box in Access?

(the lstName.Additem "wow", indexvalue in VB)

"A movement starts here and ends there. But a revolution keeps going around and around."

Thinker

You have to use the RowSource property of the Listbox. First, you need
to set the RowSourceType = "Value List". Then you can assign the
RowSource, separating the lines with a ;
List0.RowSource = "'Line1';'Line2';'Line3'"

I think therefore I am... sometimes right. [img]images/icons/wink.gif[/img]

The Cleaner

OK, got it. thanks

how would one go about having a list box being sorted automatically.... alpahbetically? I don't see it in the control properites

"A movement starts here and ends there. But a revolution keeps going around and around."

Thinker

I can't find a way to sort an unbound listbox (with values supplied to
the rowsource.) With a listbox that comes from a query, the sort is part
of the query. Sorry

I think therefore I am... sometimes right. [img]images/icons/wink.gif[/img]

The Cleaner

OK.... thats what i thought. I guess you would i have to do it programmatically. Thanks for the help



"A movement starts here and ends there. But a revolution keeps going around and around."