Want combo box to display 3 fields from my table but only displays one

  • Thread starter Thread starter vanilla_bean_orange via AccessMonster.com
  • Start date Start date
V

vanilla_bean_orange via AccessMonster.com

I have a form which someone can enter complaints. I have a combo box from
which a person can select from a list of people complaining. My problem is
when I go to run the form the combo box will only display the first field i.e
Title but not FirstName and LastName.

Can anyone help? P.S I am very new to access as you can probably tell
 
Create a query that has the 3 fields you want in your combo box. Set the
Column Count property to 3. Set the Bound Column property to the column that
is the key value for your table. Note the first column is column 0. Adjust
your Column Width property to allow the columns to display.
 
1. Open your form in design view.
2. Right-click the combo, and choose Properties.

3. On the Data tab of the Properties box, click in the Row Source property.

4. Click the Build button (...) beside this.
If the Row Source contained a query name the table will open.
If it contained a table name, Access offers to create a new query with this
table.

5. Presumably this table has a primary key field, and you need that in the
first column of your combo, so drag it into the query output grid if it is
not already there.

6. In the next column, in the Field row, enter:
FullName: Trim([Title] & " " & [FirstName] & " " & [LastName])

7. Close, answering Yes to the Update question.

8. Check the other properties are set up correctly for the combo, e.g.:
Bound Column 1
Column Count 2
Column Widths 0

The combo now has 2 columns.
It is bound to the first one (the primary key).
But the first column is zero-width, so it will display the 2nd one.
The 2nd one is the full name, all in one column, so the whole name shows.
 
Thank you Allen this worked an absolute treat!! And thanks everyone for your
suggestions

Allen said:
1. Open your form in design view.
2. Right-click the combo, and choose Properties.

3. On the Data tab of the Properties box, click in the Row Source property.

4. Click the Build button (...) beside this.
If the Row Source contained a query name the table will open.
If it contained a table name, Access offers to create a new query with this
table.

5. Presumably this table has a primary key field, and you need that in the
first column of your combo, so drag it into the query output grid if it is
not already there.

6. In the next column, in the Field row, enter:
FullName: Trim([Title] & " " & [FirstName] & " " & [LastName])

7. Close, answering Yes to the Update question.

8. Check the other properties are set up correctly for the combo, e.g.:
Bound Column 1
Column Count 2
Column Widths 0

The combo now has 2 columns.
It is bound to the first one (the primary key).
But the first column is zero-width, so it will display the 2nd one.
The 2nd one is the full name, all in one column, so the whole name shows.
I have a form which someone can enter complaints. I have a combo box from
which a person can select from a list of people complaining. My problem
Click to expand...
[quoted text clipped - 4 lines]
Can anyone help? P.S I am very new to access as you can probably tell
Click to expand...
Click to expand...
 
Back
Top