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

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

Thanks Works perfectly
have a good year