Combo Box Properties: Locked but not really... 1

[sagamw]

[access 2007]
Is there a way to prevent the user from putting the cursor inside the text part of a combo box?

I tried some properties (locked, enabled) combinations but It didn't work as expected. If you have the enable=no then you can't click the box's arrow. If it is locked you can't select a value.

I just need the combobox's arrow and the list to be functional but I don't want the user to click in the text part of the combo and try to write values in it.

 

[PWise]

set limit to list = yes

 

[sagamw]

Thanks pwise but it was yes already. You can still write text in the box. (you just get the not in the list message, that you can intercept with not in the list event etc.)

I'm looking for a way for the text part of the combo to behave as Locked, but the arrow part and the selection to remain functional.

 

[PWise]

add on the keypress event

KeyAscii = 0

 

[sagamw]

Thanks pwise.
It's not 100% (I can still click and put the cursor inside the text part of the combo) but it's good enough, so I give you a star for that.

 

[PWise]

Add to the GotFocus event

Me.ComboBoxName.Dropdown

 

[PWise]

also add this to the on change event

for pasteing<CTRl-V>

Me.CmbProviderid.Undo
Me.CmbProviderid.SelStart = 0

 

[PWise]

sorry SB

Me.ComboBoxName.Undo
Me.ComboBoxName.SelStart = 0

 

[sagamw]

Thanks again.
Nice set of commands and ideas.
Although I found that in some cases the .Dropdown forces the combolist to open twice. (You make the selection and the list pop ups again)