Problem with comboboxes; how to make them not editable 1

[JB83]

Dear reader(s),

I have generally a problem with comboboxes: the comboboxes must be non-editable, but there has to be a possibility to select a value and add it into the database. I have already searched for special variables which might could do this, but nothing found. Is there a solution for this problem or can't this be done?

Thanks in advance,

Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.

 

[mp9]

Setting the combo's LimitToList property to Yes means that only those values in the drop-down list can be selected. Is this what you want?

There are other properties like Locked and Enabled that you can play with but these will prohibit you from selecting or changing values which, if I understand you correctly, is not what you want.

HTH

http://www22.brinkster.com/accessory/

 

[JB83]

Mp9,

thank you for your fast respond! It is not exactly what I wanted, but it is the best property for locking the combobox. This is not your fault of not understanding me correctly (which you did) , but the limit of property adjustments in VB itself.

I actually would like that the combobox doesn't show a (blinking) cursor at all, it only has to show the values which are in the combobox. The NotInList property is not exactly what I wanted, but it reaches almost. If it's not possible what I want: too bad.

Thanks anyway!



Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.

 

[mp9]

You could further encourage use of the drop-down by putting

ComboFieldNameHere.Dropdown

in the combo's OnGotFocus event maybe?

http://www22.brinkster.com/accessory/

 

[JB83]

I'll try that later, thanks for your respond!

Jochen. --------------------------------------------------------------------------------
It never hurts to help and it never helps to hurt.