By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,984 Members | 2,615 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,984 IT Pros & Developers. It's quick & easy.

Auto Scroll List Box Access 2000 VBA

P: 11
I'm looking for some way to use VBA in Access 2000 to scroll my list boxes so the selected record is in view.

I am running a process that updates some fields shown on the list after a user has selected some records. It updates, refreshes the list then selects the next record on the list.

Unfortunatly when you re-query a list the top records are displayed. Simply selecting the record using something like Me.lstSuspend.Selected(varList + 1) = True correctly selects the record but does not bring it into view.

TopIndex does not work and I have been unable to find any other solution. I'm reluctant to use some sort of setfocus and send keys combination.

Any help yould be appreciated.
Nov 5 '08 #1
Share this Question
Share on Google+
2 Replies

Expert Mod 2.5K+
P: 2,545
Hi. Sorry to say I reckon this one is a problem with A2000's implementation of listboxes, as using the listbox Select method in A2003 consistently brings the relevant listbox entry into view within the listbox itself. Wish I could suggest a workround for it...

Nov 7 '08 #2

P: 11
Many thanks, I did not think there was a way of doing this. I have currently set the multi select to none which helps it to keep the current selection in view, however I would really like the users to be able to select multiple things at once. Oh well perhaps one day this company I work for will upgrade it's office suite, hellooo it is almost 2009 now.
Nov 9 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.