Combobox doesn't show data 1

[projecttoday]

It might be something simple. I have a combobox on a form which is bound to the id code of another table and also should show the field description in that table. But the drop-down list shows up blank. Click on it somewhere, and a description displays in the combo and the id is stored in the table just like it's supposed to. Obviously it should display the description field in the list so the user will know what to select. Any ideas? I have attached it here. Open form frmAssemblies and try combobox "code". Where are the descriptions (field sysdescription in table tblSystems)? They can be clicked but they show blank. It's probably something really obvious.

 

[projecttoday]

Sorry, I couldn't get the attachment to work. Does anyone know why a combobox won't display data?

 

[MajP]

take a look at the following properties of the combo

Column count
bound column
column widths

What do they say.

 

[projecttoday]

Column count is 2
bound column is 1
column widths are 0" and 5"

I've tried varying the widths of the second column both in the properties and the width of the combobox but it won't display.

I could post it here. How do you do that?

 

[PHV]

If ac2003sp3:

http://support.microsoft.com/kb/945674/

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[projecttoday]

I just tried it on a computer that has Access 2002 (instead of 2003) and it works there. Thank you.