scroll to an item on a listbox

[philfer]

Hi,

I have a problem that doesnt exist when I use it in Excel but doesnt work in Access

I have a form with two listboxes.

The first fills with field heading from a table and when you press a button with > on it the item moves to the second list box

The issue I have that if I do this for an item quite far down on the list (there are vertical scrollbars) I can get the next item to be selected using the selected property but I cannot get it to be visible in the listbox (the listbox scrolls back to the top

Is there any way to get it so that is stays on the visible item

Cheers
Phil

[OBP]

Can you supply an Access 2003 version?

[philfer]

Hello OPB

I have added an Access 2003 version.

Thanks for any help you have
Phil

[OBP]

Phil, the Access 2003 version that posted for me does not do what you describe.
When you select an item the left hand list cursor stays where you selected the item.
When you delete one from the right hand side it does go to the bottom of the left list though.

[philfer]

Hi OPB,

Thats so strange!

I just opened it again on my system and when I scroll down to Parent in the left list and press > the left list springs back to the top.

If I then select Parent from the right list and press < it puts it back into the second last position where it originally came from.

Does this not happen to you?!?!?!?!?!

Cheers
Phil

[OBP]

No it is the opposite way around, the left one works OK and the right one goes to the bottom of the list.
Perhaps it is an Access 2003/2007 difference.

[OBP]

Duplicate post