Dropdown a combo with center click

[Jesper F]

I'd like a combo to behave the same way the combos in fx.
the vba editor of Access behave.
That is dropping down with one click with the mouse in the
white area of the combo (not on the arrow).
Thus it wouldn't be possible to type any characters in the
control. Can this be done in Access?

 

[Rick B]

Do you have the "auto-expand" property set to true?

Rick B


I'd like a combo to behave the same way the combos in fx.
the vba editor of Access behave.
That is dropping down with one click with the mouse in the
white area of the combo (not on the arrow).
Thus it wouldn't be possible to type any characters in the
control. Can this be done in Access?

 

[Rick B]

You could also put code in the forms 'enter' event...

Private Sub SomeFieldName_Enter()
SomeFieldName.Dropdown
End Sub




I'd like a combo to behave the same way the combos in fx.
the vba editor of Access behave.
That is dropping down with one click with the mouse in the
white area of the combo (not on the arrow).
Thus it wouldn't be possible to type any characters in the
control. Can this be done in Access?

 

[Jesper F]

You could also put code in the forms 'enter' event...

Private Sub SomeFieldName_Enter()
SomeFieldName.Dropdown
End Sub

Thanks. I could, but the user would still be able to type
characters in the field. I was just wondering if it could
be made impossible to place a cursor in the field. I don't
think it can in access though.

 

[Pawel / eGEO.pl]

Hi Jesper,

I did so, by putting a transparent textbox withing the combobox and
coding the onclik event this way:
me.cbobox.dropdown.
What's more you could code the onmouse over event of the combo box to make
it drop down and while outside it to
roll back.
Regards,
Pawel