in combo box I want to show Code and Description

[smg]

I created a combo box based on a query with Error Code and Description. When I view the form I want to see both fields, however, only Error Code Field displays. How do I get both to display?

[pbaldy]

http://www.baldyweb.com/Autofill.htm

or you can create a concatenated field as the visible field of your combo.

[Micron]

you usually need a combo column for every field that is in the combo's row source. You either don't have enough columns, or some have their widths set to zero. Column widths and count properties are on the property sheet Format tab.

[Micron]

The Column property is zero based, so 2 is the third column

Ummm, with all due respect, I don't think so. Not according to M$.

The ColumnCount property holds an integer between 1 and the maximum number of fields in the table, query, or SQL statement, or the maximum number of values in the value list, specified in the RowSource property of the control.

While zero is a valid value for the property, if used it refers to the Index (row number) of a list item thus it isn't part of the row source. If the row source has 3 fields, the column count is 3, and 3 is the 3rd column. I used to think it was zero based as well - because of similar counts being zero based and the fact that zero is a valid column property. It's just not a 'member' of the row source.

Am I interpreting that statement incorrectly?
EDIT
Seems that I am, somehow. I should play in the sandbox before throwing any sand.
Now I have to figure out where I got 0 as the index of a row. Perhaps listbox...
Edit2 - I see that I confused the ColumnCount property with the Column property.

[smg]

i changed the column count to 2 in the format tab and that did the trick! Thank you all.