<div>
Both work, although I went with Cap's as I forgot to mention that while I have &quot;bananas&quot;, the bound column in the listbox was basically the FruitID. &nbsp;Thanks. &nbsp;-Jim
</div>


Both work, although I went with Cap's as I forgot to mention that while I have "bananas", the bound column in the listbox was basically the FruitID.  Thanks.  -Jim

<div>
btw ... is there just one column in the list box ?
</div>


btw ... is there just one column in the list box ?

<div>
There were five, but I butchered the example.
</div>


There were five, but I butchered the example.

<div>
<div class="content wysiwyg-content">
Hi guys<br />
<br />
I have an Access list box that populates fine. &nbsp;No rows are selected. <br />
Example: &nbsp; &quot;apples&quot;, &quot;oranges&quot;, &quot;bananas&quot;, &quot;watermelon&quot;.<br />
<br />
Question: &nbsp;What is the VBA code to programmatically select an item (say &quot;bananas&quot;) in the list box? &nbsp;<br />
<br />
I see the .ItemsSelected property, but it seems to only apply to all items selected. &nbsp;<br />
<br />
Thanks in advance.<br />
Jim
</div>
</div>


Hi guys

I have an Access list box that populates fine.  No rows are selected. 
Example:   "apples", "oranges", "bananas", "watermelon".

Question:  What is the VBA code to programmatically select an item (say "bananas") in the list box?  

I see the .ItemsSelected property, but it seems to only apply to all items selected.  

Thanks in advance.
Jim

Access listbox:  VBA to select an item

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.