I want to present some information in a form, read only, using a field which contains a numeric index to another table. The other table contains the text description that I wish to present on my form.

Using a Combo Box I can set the object's Row Source to select the ID and text description fields from the source table, bind the query to the first column and use the Column Count parameter to display the text description. To make the object read only I can set Enabled to No. However, the drop-down arrow remains visible of course, as this is a Combo Box.

Using a Text Box I cannot work out how to display anything other than the numeric index value.

My query then - is it possible to hide the drop-down arrow when using a Combo Box in this way, or alternatively (and preferably), is there a way to use the ID field as an index with a Text Box?