2 columns in combo box, only one appears in list box

[Nate1749]

I've got a combo box that shows "Month | Year". Once you select a row, only Month shows. Since month is a fixed amount of space, I think I am supposed to create a text box and have it equal the year field? Or maybe there's another way that I can't think of. Thanks,

-Nate

 

[SgtJarrow]

A combo box only shows the first field after a selection no matter how many are displayed in the drop down. The simpliest solution to your problem is as follows:

Go to properties of the combobox, and select row source. Click the elipse at the end of this field. Insert a new field at the beginning of the query builder window. In this field put:
[Month] & " " & [Year]

You may need to change the month and field names to match what your are.

Close this builder window and say yes when it asks if you want to update the query.

Finally, in the properties window for the combobox, set the column count property to 3, set the bound column property to 1, and set the column width property to 0";1";1";

You should now get your desired display with the correct data being used...

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, MCP, Network+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com