Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    List Box (Access97)

    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

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Box (Access97)

    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
    Francois

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Atlanta, Georgia, USA
    Posts
    274
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: List Box (Access97)

    Thank you that did the trick

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •