<div>
is this a multi select listbox?<br />
yes, you can store the value selected to a variable. <br />
<br />
can you explain this &nbsp;<br />
{ and then return the list box to that position at a later point in code. }
</div>


<div>
yes it is a multi select list box.<br />
<br />
<br />
I need to store in a variable where the scroll bar is. &nbsp;(ex. &nbsp;half way down)<br />
<br />
I have code that will requery the list box which moves the scroll bar to the top.<br />
<br />
I then want to move the scroll bar back down to the position that I saved in a variable.
</div>


<div>
if you select more than one item, which one are you going to store?
</div>


<div>
i think you're missing what I'm after. &nbsp;I don't want to store the data is the list box. &nbsp;<br />
<br />
I could select 100 items but I only need to store 1 thing - the POSITION OF THE VERTICAL SCROLL BAR.<br />
<br />
I have code that will do it for a form. &nbsp;I am just looking for code that works for a list box.
</div>


<div>
{ i think you're missing what I'm after } no.<br />
<br />
are you adding records to the list box, before the requery? 
</div>


<div>
I appreciate you looking for a different approach to the solution, I'm not sure if it will work though.<br />
<br />
The list could be reloaded for a variety of reasons:<br />
&nbsp; The user can select any number of records and remove them from the list. &nbsp;<br />
&nbsp; The user can add records to the bottom of the list.<br />
&nbsp; The user could select multiple records and move them up or down the list (reordering the list)<br />
<br />
The list also contains code to produce different levels of indenting in the rows. &nbsp;Thus, I need to completely wipe out the list and repopulate it. <br />
<br />
I know I don't have to actually store the position of the scroll bar. &nbsp;I could store a value in the list. &nbsp;Even if I do that, I still need code to scroll down the list box and return to the position. &nbsp;<br />
<br />
Even code that moves the scroll bar to the end of the list box would be helpful.
</div>


<div>
to move to the middle you can do this<br />
<br />
me.list0.setfocus<br />
me.list0.listindex=(int(me<wbr />.list0.lis<wbr />tcount/2)-<wbr />1)
</div>


<div>
Thanks!<br />
<br />
I found this link. <a href="https://www.experts-exchange.com/questions/22114771/scrolling-a-list-box-in-extended-multiselect-using-VBA-code-Not-using-sendkeys.html" rel="ugc">https://www.experts-exchange.com/questions/22114771/scrolling-a-list-box-in-extended-multiselect-using-VBA-code-Not-using-sendkeys.html</a>&nbsp; <br />
I haven't tried it yet. &nbsp;<br />
<br />
Although your solution may not be quite as precise it will work great for my needs and is a lot simpler.<br />
<br />
Thanks again.
</div>


<div>
<div class="content wysiwyg-content">
In VBA in Access 97 how do I change the vertical scroll bar position of a list box?<br />
<br />
Preferably I need to be able to get the vertical scroll bar position, store it, and then return the list box to that position at a later point in code.
</div>
</div>


In VBA in Access 97 how do I change the vertical scroll bar position of a list box?

Preferably I need to be able to get the vertical scroll bar position, store it, and then return the list box to that position at a later point in code.

Change scroll position of a list box

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.