Hiding an ID field in a drop-down list
How to display an ID field in a closed combo box but hide it in a drop-down list.
Q: Rich writes that he needs to display an ID field in a closed combo box, but doesn’t want it to appear in the drop-down list. The field is the first one in the combo box’s row source, and it is the bound field.
A: This can be done by setting the column width for the first column of the combo box to a very small width – say .05 in. The column will be so narrow you can’t see it in the drop-down list, but since it is the bound field, the ID will show in the combo box once it is closed.