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.

Want More?

Office Watch has the latest news and tips about Microsoft Office.  Delivered once a week.