Combo Box List

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it possible to make the combo box selection list draw from more than one
field? In other words, can I merge several fields into one column list?
Sorry if this is not posted into the correct discussion area.
 
Is it possible to make the combo box selection list draw from more than one
field? In other words, can I merge several fields into one column list?
Sorry if this is not posted into the correct discussion area.
Click to expand...
Sure.
As Rowsource of the combo box, try something like this:

Select [LastName] & ", " & [FirstName] as FullName From TableName
Order By [LastName] & ", " & [FirstName];
 
Sorry, I guess I did not make my problem clear enough. I do not wish to
concatenate Field1, Field2, etc, but rather have what is in Field1, Field2,
etc become individual items in the dropdown list.

fredg said:
Is it possible to make the combo box selection list draw from more than one
field? In other words, can I merge several fields into one column list?
Sorry if this is not posted into the correct discussion area.
Click to expand...
Sure.
As Rowsource of the combo box, try something like this:

Select [LastName] & ", " & [FirstName] as FullName From TableName
Order By [LastName] & ", " & [FirstName];
Click to expand...
 
You do this in the rowsource, column count and column width properties. The
fields you want in the dropdown list must first be in the rowsource (table
or query). For your example, typically you would have ID, Field1 and Field2
in your row source. You have three fields so you need to set the column
count property to 3. Column Widths is a string of the column width of each
field where each is separated by a semicolon. Most likely you would not want
to display the ID field so you would set its width to 0. Say fields Field1
and Field2 each need 1.5" to display. So your column width property string
is:
0;1.5;1.5

Note that you can not display two fields as the value of the combobox after
you make a selection. The value displayed is the first column where the
width is not 0 or if the Bound Column property is greater than that column
number, the bound column is displayed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


EdS said:
Sorry, I guess I did not make my problem clear enough. I do not wish to
concatenate Field1, Field2, etc, but rather have what is in Field1, Field2,
etc become individual items in the dropdown list.

fredg said:
Is it possible to make the combo box selection list draw from more than one
field? In other words, can I merge several fields into one column list?
Sorry if this is not posted into the correct discussion area.
Click to expand...
Sure.
As Rowsource of the combo box, try something like this:

Select [LastName] & ", " & [FirstName] as FullName From TableName
Order By [LastName] & ", " & [FirstName];
Click to expand...
Click to expand...
 
Appreciate your help.

PC Datasheet said:
You do this in the rowsource, column count and column width properties. The
fields you want in the dropdown list must first be in the rowsource (table
or query). For your example, typically you would have ID, Field1 and Field2
in your row source. You have three fields so you need to set the column
count property to 3. Column Widths is a string of the column width of each
field where each is separated by a semicolon. Most likely you would not want
to display the ID field so you would set its width to 0. Say fields Field1
and Field2 each need 1.5" to display. So your column width property string
is:
0;1.5;1.5

Note that you can not display two fields as the value of the combobox after
you make a selection. The value displayed is the first column where the
width is not 0 or if the Bound Column property is greater than that column
number, the bound column is displayed.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com


EdS said:
Sorry, I guess I did not make my problem clear enough. I do not wish to
concatenate Field1, Field2, etc, but rather have what is in Field1, Field2,
etc become individual items in the dropdown list.

fredg said:
On Thu, 4 Nov 2004 10:08:01 -0800, EdS wrote:

Is it possible to make the combo box selection list draw from more than one
field? In other words, can I merge several fields into one column list?
Sorry if this is not posted into the correct discussion area.
Sure.
As Rowsource of the combo box, try something like this:

Select [LastName] & ", " & [FirstName] as FullName From TableName
Order By [LastName] & ", " & [FirstName];
Click to expand...
Click to expand...
Click to expand...
 
Hi,


You can either use multiple columns, either use a single column from a
query that would concatenate many fields together. To use multiple columns,
individually, start with the control wizard. In the second case, have your
saved query already debugged and saved when you add the list control (you
can also change the SQL statement of the RowSource of the ListBox).



Hoping it may help,
Vanderghast, Access MVP
 
Back
Top