Problem with combo box in form truncating information

[craigugoretz]

Hello,

I have designed a database using combo boxes in forms. In many instances when the combo boxes require more than one field, I have been writing SQL queries to concatenate the fields together into one column separated by commas. For instance, take this table of names:

ID Last name First name
-- ---------- ----------
1 Johnson Steve
2 Jackson Peter
3 Simpson Homer

In my combo box I have these selections:

Jackson, Peter
Johnson, Steve
Simpson, Homer

I can select one of them, and everything is fine. However, in one of my forms, the combo box items are split into two columns: (1) the selections given above, but truncated (there is only about 1" of space) and (2) a longer blank column. Interestingly, when I make a selection, the full text is given in the text portion of combo box and there is no truncation there.

Any ideas?

Thanks, Craig
Access 2007
Windows 7

[June7]

Try changing column widths with the ColumnWidths property.

[craigugoretz]

The column widths property on the table is set to 0";3". I could not find a columns widths property on the form. The SQL to populate the combo box is:

SELECT Media.ID, [Media].[Title] & ", " & [Media type].[Media type] & ", " & [Media].[Code number] AS Expr1
FROM Media, [Media type]
WHERE ((([Media type].ID)=[Media].[Media type]));



The combo box displays this as an option:
[The ABCD Read| ]

Selecting this option yields the following text in the combo box:
The ABCD Reader, Test 2, 123456

The bound column for the combo box is 1.

I think there is more the matter besides the columns width property on the table.

-- Craig

[rpeare]

That can't be your SQL statement can it? if you're using two tables (MEDIA and MEDIA TYPE) don't you need a link? or is this a cartesian join?

[June7]

Combobox ColumnWidths property is on the Format tab of Properties Sheet when the combobox is selected in Design view.

The WHERE clause will act somewhat like a JOIN clause but probably better to use the JOIN clause.

[craigugoretz]

Thank you,

I found the column width property and changed it to 0";4" and everything fit.

-- Craig