If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
BoundColumn property
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. |
#2
|
|||
|
|||
BoundColumn property
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" wrote in message ... 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. |
#3
|
|||
|
|||
BoundColumn property
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. |
Thread Tools | |
Display Modes | |
|
|