Disable Mouse input on Dropdown

[sonny123]

I have a data entry form, corectly tab indexed etc changes colur where the focus is and everthing.

there are three dropdowns which drop down on the onenter event and whose values depend on previous entries.

Despite advice to the contrary
Users insist on using the mouse to select values from the dropdown and in their haste often make mistakes.

is there a way to force users to use keyboard to input to the dropdown

or any other ideas???

I tried experimenting with onclick type events to change the focus back to the first field which would really annoy the user but would soon teach them to use the keyboard.

 

[ChrisO]

You could cancel the mouse down event of the combo box, for example:-

Private Sub cboJob_MouseDown(Button As Integer, Shift As Integer, X As Single, Y As Single)
    DoCmd.CancelEvent
End Sub

Chris.

 

[sonny123]

Thanks
i just tried it
It prevents the mouse from droping down the menu on the control

but i have the control set to .dropdown on the OnEnter event
(this is neccessary as the value in the drop down depend on previous entry)

and the mouse can still select the values

there must be another way to skin this cat

 

[ChrisO]

I can not reproduce the effect you are getting.

I am only testing it in Access 2003. Can you please post a small demo in Access 2003?

Chris.

 

[sonny123]

perhaps i should have mentioned this is a continous subform
I have only access 2007

using DoCmd.CancelEvent on the mousedown doesnt seem to effect the mouse being able to 'select' the values from the dropdown once the values are revealed by the 'onenter event' 'myctrl.dropdown' . But It does stop the mouse being able to .dropdown the control.

I also have tried Drawing a Transparent button over the boxes so they cant be clicked by the mouse but still the mouse can select values once the controll has droped down the list.