scrolling a listbox

[StuJol]

i have an access 2003 database. i have a listbox on a form named "List0". I
use the additem method in vb code to update the values in the list box. i may
add 100 values to the list box. what im trying to do via vb code is to scroll
the listbox to the bottom everytime i update it so the latest item to be
added is always visible.

does anyone know how to acheive this?

 

[Danny Seager]

try

Me.List0.Selected(Me.List0.ListCount - 1) = True

 

[Jeff Boyce]

I can't tell from your description whether you are adding items to a table
underlying the listbox, or adding values directly to the listbox. If the
latter, have you considered using a table as a source via a query. It might
be more maintainable.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[StuJol]

Many Thanks, Works Great

try

Me.List0.Selected(Me.List0.ListCount - 1) = True

 

[StuJol]

its works except for one thing! i can see the list box updating as the black
bar scrolls down but no text is visible? if i add msgboxes into the code,
clicking ok refreshes the listbox and i can see the values.

any ideas?