combo box/invisible data/type mismatch

[stephenaa5]

OK, I'll start by saying I know this is ridiculous. I have a split form that overlays a table. One of the fields is called MS5, a text field. I need to have a combo box cover that field, in order to control inputs. If I do so, the data in the field becomes "invisible", and sorting by that field yields "type mismatch." If I remove the combo box, and use a text box, everything is fine, works correctly, data is visible, but I cannot then control the inputs.



I have created them both "by hand" and using the wizard, with the same results.

This form has several combo boxes. None have this issue.

It has to be something ridiculously simple.

Using access 2007


Thanks for your suggestions.

[John_G]

Did you try setting the "locked" property of the text box to "Yes"? That keeps it visible, but prevents any editing.

HTH

John

[stephenaa5]

Thanks, but it doesn't work. I did recreate it AGAIN, and for some reason now it's visible. However, the data issue is still there. Sorting results in a type mismatch. I don't get it.