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.

Windows 10 Spring 2018 Creators from people 'in the know'

A detailed and independent look at Windows 10, especially written for the many people who use Microsoft Office.

Fully up-to-date with coverage of the 2018 Spring Creators edition 2016 major update of Windows 10.

This 800 page book shows you important features and details for all serious Windows 10 users.