Access2007 - Secret Trick 01

I wanted a drop-down (ComboBox) with two columns. The first column holds the ID of the row I'm looking at and the second column holds the information, in this case the Subsystem. I want to see Subsystem in the drop-down but use the ID in my database. I don't want the ID to be displayed in the drop-down.

Here's the secret. Set the first column width to 0! The Column Widths property is a comma delimited list of widths so you can define it for every column displayed, or not display a column.