List Box (Access97)

Topic

New Reply

Is there a way to move to the last record of a listbox when the form it is on is opened?
My listbox has 300 records and until you get to the bottom of the list the scroll works very slow.
Once you get to the bottom , scrolling is very fast up or down.
Thanks,
Scott

Reply | Quote

Replies

Scott,
put this code in the on open event of the form where lstName the name of your listbox is

Me.lstName.SetFocus
Me.lstName.ListIndex = Me.lstName.ListCount -1

Reply | Quote

Thank you that did the trick

Reply | Quote