Text box portion of combo box appears to be locked

[tango1948]

Hi,
My combo boxes seem to have the textbox portion locked. When I select an item from the dropdown list it appears in the textbox, but I'm unable to enter any values from the keyboard. The combo box properties are:

Row Source Type: Table/Query
Row Source: Select Distinct field from table order by
field.
Bound Column: 1
Limit to list:.....Yes
Auto Expand:.......Yes
Enabled:...........Yes
Locked:.............No
Allow AutoCorrect:..No
Text Align..........Right

I'm using Access 2000. Any suggestions as to what might be causing this behaviour.

Thanks for any help

David

 

[fneily]

Do you type in something and get a message you must pick from the list?
Limit To List make NO.

 

[tango1948]

Hi fneily,
Thanks for the reply, I don't get any message, I tried Limit to List = No, no change textbox still acts as if its locked.

 

[fneily]

Have you checked for any coding that locks the comboboxes, such as OnOpen of the form or any Afterupdates of other controls?

 

[MajP]

If I understand correctly the drop down portion works fine and can save data; however, you can not type into the text box portion. If this was locked you would not get this behavior. Two thoughts. The control or form are corrupted. Delete the control and readd it. Compact and repair the database. Compile the code.
The other thought is maybe this is a feature in 2007, I do not have 2007 so can not tell you. The reason I say this you can get this feature on a MSforms 2.0 combobox. There is a format option to select "drop down list". It looks like a combo not a listbox and you can drop down the list like a combo, but you can not type in it. I doubt you add a forms control because I think you would know it.

 

[tango1948]

Hi,
The combo boxes are not locked their behavior is simular to being locked. I've tried deleting and readding the control but it happens on all the comboboxes - i have three on the form and I can't enter data from the keyboard into any of them apart from that they all work ok. I'm using Access 2000 I've tried Compact and repair no change.
How do I compile the code? I created an mde file but I still can't enter any data from the keyboard.

 

[fneily]

Have you tried recreating a BRAND NEW form with BRAND NEW comboboxes?

 

[tango1948]

Hi fneily
Thanks that solved the problem I created a new form
copied the controls everything works.
Don't know what the problem is/was I compared properties of the two forms - no difference. I guess its somewhere in the code but why all the combo boxes?
Thanks all, good to have someone to talk to