Disable Cursor Inside DropDownList?

[crhodus]

Is there a property that can be set that will protect my dropdown list so that the cursor is not inside the dropdown list, but still allow the user to choose something? I've been playing around with this for a while, but I haven't been able to prevent this from happening.

Thanks!

 

[Fizzio]

Why do you want to disable the cursor in the box?

 

[Uncle Gizmo]

You could "Lock" your list box, then move through the list with 2 command buttons, "Up" and "Down" and then "Select" an item with another command.

You should be able to adapt this code:-

 

[crhodus]

I'm just trying to prevent the user from keying or deleting the text that is in the dropdown list. I would like it to behave more like an html dropdown list.

 

[Mile-O]

You are describing the Microsoft Forms 2.0 Combobox ActiveX Control.

It's in: Insert -> ActiveX Control

then look through the controls until you see the one named above.

You'll have to register it. Once this is done, you set its Style property to DropDownList.


I've never used it myself so can't offer any other information.

 

[crhodus]

Is there not an existing property in Access that will prevent the user from modifying text in the dropdown list but still make a selection with the dropdown when creating a record?

 

[Mile-O]

You could try the KeyPress event of the combo.

on this event:

Private Sub cboMyCombo(Keycode as Integer,bla bla bla
   KeyCode = 0
End Sub

 

[crhodus]

Thanks for your help!

 

[pcEars]

Is there not an existing property in Access that will prevent the user from modifying text in the dropdown list but still make a selection with the dropdown when creating a record?

the property "limit to list" should do that, shouldn't it guys?

 

[Uncle Gizmo]

the property "limit to list" should do that, shouldn't it guys?

I agree (Can't spell concure)