Combo Boxes

[kev]

Hi Im looking for some way
of auto expanding a combo box
when the field has focus
so that the user automatically
sees the choices

 

[R. Hicks]

Use the On Got Focus event of the combobox:

Private Sub YourCboboxName_GotFocus()
Me![YourCboboxName].Dropdown
End Sub

Change "YourCboboxName" to the name of your combobox.

HTH
RDH

 

[kev]

Thanks Works perfectly
have a good year