This video demonstrates the setup of a combobox in Access with more than one (1) column. Shows how to change and hide the bound column, which specifies the value that Access stores .

Instead of using the wizard, this shows how to build the RowSource for a combobox like you would a query, which makes things easy. Also shows setting Column Count and Column Widths on the Property Sheet.

By default, the Bound Column of a combo box is the first one, with the value that Access stores. This video initially shows changing the bound column -- however, that isn't commonly done, as demonstrated next. Instead, the bound column is often hidden by settings its width to 0 (zero) in ColumnWidths so Access can store a value such as a number but show meaningful text to the user.

This example demonstrates only 2 columns -- one hidden and one visible ... but you can have more columns. Comboboxes are great to show meaningful values while storing something cryptic

~~~
NOTE: Not mentioned is that you can create a textbox with ControlSource
= combo_controlName.Column(#)

where
combo_controlName is the NAME property of the combo box
# is the column index number you want to display (in another control since combo only shows first visible column unless the list is dropped). Column index numbers start with 0 (collection is zero-based).

'Name' is used for demonstration only. In reality, 'Name' is reserved and shouldn't be used for a field or object name.

'State' is also a reserved word, so take care when using.

~~~
Reference to first combobox video by DataPig:

[ Ссылка ]

~~~
This video has been resurrected from an older Access tutorial series by DataPigTechnologies. Even though Access looks different now, the concepts and functionality persist. Thanks to owner, Mike Alexander, for making these videos available for presentation once again. Thanks also to Jack Drawbridge and John Clark for helping get these valuable lessons back online.

свернуть