If you want to just view it like a text box, why not just change it to
a text box?
Anyway, you can make a small rectangle, sized big enough to cover the
dropdown button. Set it on top of the button.
Set it's BackStyle to Normal, it's BackColor to whatever the color is
of the surrounding form, it's Special Effect property to Flat, and
it's Border property to Transparent. Then click Format + Bring to
Front.
Next set the combo box Enabled to No, and It's Locked property to Yes.
You can view the combo box data but it cannot be changed.
I agree with your first idea. Why go through all the
hassles to make a ComboBox look like a TextBox?
If there is any need to display the value in the unbound
Column of the Column of the ComboBox, then there are
Recordset & DLookUp to retrieve this with the value used
in the "bound Column" f the ComboBox.