Prev: Using the second column of a lookup field in row source
Next: Sorting Combo box items
From: gator on 1 Jun 2010 13:03
Can someone please explain in layman terms, the purpose of BoundColumn in
ComboBox in terms of viewing two columns when dropped down and storing one
value in the table and displaying different value in the form?

I want to be able to see two columns in drop down mode, column 1 value
stored in table and column 2 value displayed in form data view.
From: Douglas J. Steele on 1 Jun 2010 13:56
Since you want the value of the first column to be stored in the table, set
the BoundColumn to 1.

Since you want the value of the second column to be displayed, set the
ColumnWidths property to 0. (if you really wanted to, you could set it to,
say, 0;1" to ensure that the second column only shows as 1 inch wide)

Make sure the ColumnCount property is set to 2.

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/DJSteele
Co-author: Access 2010 Solutions, published by Wiley
(no e-mails, please!)

"gator" <gator(a)discussions.microsoft.com> wrote in message
news:5BCBFD5A-B2A9-4B40-B14C-543AEB1CF3CF(a)microsoft.com...
> Can someone please explain in layman terms, the purpose of BoundColumn in
> ComboBox in terms of viewing two columns when dropped down and storing one
> value in the table and displaying different value in the form?
>
> I want to be able to see two columns in drop down mode, column 1 value
> stored in table and column 2 value displayed in form data view.


From: Rick Brandt on 2 Jun 2010 01:58
gator wrote:

> Can someone please explain in layman terms, the purpose of BoundColumn in
> ComboBox in terms of viewing two columns when dropped down and storing one
> value in the table and displaying different value in the form?
>
> I want to be able to see two columns in drop down mode, column 1 value
> stored in table and column 2 value displayed in form data view.

The column value you see when the ComboBox is not dropped is always the
left-most column with a non-zero width. You can store any column you want
and that can even be a column that you do not show, but the first visible
column in the drop-down is always the column shown when not dropped down.

 | 
Pages: 1
Prev: Using the second column of a lookup field in row source
Next: Sorting Combo box items