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
|
|||
|
|||
Combo box and data
Hi,
My combo box has three columns. As normal, it shows only one column after choosing the record from the list. Please show me how to make the combo box shows all three columns. Thanks Chi |
#2
|
|||
|
|||
Combo box and data
Ciao Chi wrote:
Hi, My combo box has three columns. As normal, it shows only one column after choosing the record from the list. Please show me how to make the combo box shows all three columns. Thanks Chi He is not able' -- Ciao Geppo |
#3
|
|||
|
|||
Combo box and data
On Mon, 31 Dec 2007 09:29:00 -0800, Chi wrote:
Hi, My combo box has three columns. As normal, it shows only one column after choosing the record from the list. Please show me how to make the combo box shows all three columns. Thanks Chi You can't show more than one column after selection. What you can do is add an additional text control for each of the other columns you wish to show. Set it's control source to: =[ComboName].Column(1) Because Combo Boxes are Zero based, the above will show the second column. Change (1) to whatever the actual column number is. -- Fred Please respond only to this newsgroup. I do not reply to personal e-mail |
#4
|
|||
|
|||
Combo box and data
Open the properties sheet for your combo box, go to the format tab, and set
the column widths to something like; 1";1";1" HTH -- _________ Sean Bailey "Chi" wrote: Hi, My combo box has three columns. As normal, it shows only one column after choosing the record from the list. Please show me how to make the combo box shows all three columns. Thanks Chi |
#5
|
|||
|
|||
Combo box and data
On Mon, 31 Dec 2007 09:29:00 -0800, Chi wrote:
Hi, My combo box has three columns. As normal, it shows only one column after choosing the record from the list. Please show me how to make the combo box shows all three columns. Thanks Chi A couple of possibilities: 1. Base the Combo on a Query with a calculated field concatenating the three fields. 2. Put two additional textboxes on the form next to the combo, with control sources like =comboboxname.Column(n) where n is the *zero based* index of the field that you want to see. John W. Vinson [MVP] |
#6
|
|||
|
|||
Combo box and data
What exactly are you using this combobox for?
-- There's ALWAYS more than one way to skin a cat! Answers/posts based on Access 2000/2003 Message posted via http://www.accessmonster.com |
#7
|
|||
|
|||
Combo box and data
As descriped in the other posts, the combo-box will only "Display" the
selected item once selected. That is the nature of the object. You can change the properties of the combo box (on the Format tab) by putting the total number of columns in the "Column Count" field and then the desired column widths in the "Column Widths" field (something like 1";1";1"). This will allow you to "See" all the fields during the selection process. Once selected, only the data for the actual selection will show. However, if you create unbound text fields and set the control sourse to "=[ComboName].Column(x)" (where x equals the column you what to display [remember they start with 0 and increament upwards]). Set these fields to locked and uneditable to reduce confusion for the user. |
#8
|
|||
|
|||
Combo box and data
Once selected, only the data for the actual selection will show. However, if
you create unbound text fields and set the control sourse to "=[ComboName].Column(x)" (where x equals the column you what to display [remember they start with 0 and increament upwards]) you will be able to see the other data. Also, set these fields to locked and uneditable to reduce confusion for the user. |
Thread Tools | |
Display Modes | |
|
|