Does anyone know code to automatically expand a combo box list when the
control receives the focus and collapses it when the focus is lost?

Thanks

In the Enter event, or GotFocus event use:

Me.ComboBoxName.Dropdown

When you exit the combo box control the list will retract.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"Graham Walker" <(E-Mail Removed)> wrote in message
news:465c37cf$0$90645$(E-Mail Removed)...
> Does anyone know code to automatically expand a combo box list when the
> control receives the focus and collapses it when the focus is lost?
>
> Thanks
>
>

Thank you Arvin for your quick reply. I just used your code and it works
like a charm.

Thank you again.


"Arvin Meyer [MVP]" <(E-Mail Removed)> wrote in message
news:eXQ%(E-Mail Removed)...
> In the Enter event, or GotFocus event use:
>
> Me.ComboBoxName.Dropdown
>
> When you exit the combo box control the list will retract.
> --
> Arvin Meyer, MCP, MVP
> http://www.datastrat.com
> http://www.mvps.org/access
> http://www.accessmvp.com
>
> "Graham Walker" <(E-Mail Removed)> wrote in message
> news:465c37cf$0$90645$(E-Mail Removed)...
>> Does anyone know code to automatically expand a combo box list when the
>> control receives the focus and collapses it when the focus is lost?
>>
>> Thanks
>>
>>
>
>