Naomi is right, a different RowSourceType would work better, like 3 or 5 for instance.
Or use a different ControlSource field-type, i.e. Int < s >
(BTW, if you want to see only one column in the drop-down, you do not need to set ColumnWidths = "200,0" if you leave ColumnCount=1 && default)
hth
-Stefan
>I'm having a frustrating problem with what should be a simple use of a combobox.
>
>The problem is that the combobox does not show the currently selected value (displayvalue) properly -- either when it first comes up (where its controlsource is already assigned a value that matches an entry in its rowsource), or when I click on an item in the dropdown.
>
>The crsr_Employees table is simple -- field 'name' is character, field 'empidnum' is numeric.
>
>(Note that even though the item clicked on does not show up correctly in the combobox, the correct value is saved correctly in the controlsource.)
>
>BTW -- there is NO method or event code for this combobox -- plain old vanilla stuff.
>
>Help!
>
>
ADD OBJECT updatetable1.cntupd.cntedit.combo1 AS combobox WITH ;
> FontSize = 10, ;
> BoundColumn = 2, ;
> ColumnCount = 2, ;
> ColumnWidths = "200,0", ;
> RowSourceType = 6, ;
> RowSource = "crsr_Employees.name, empidnum", ;
> ControlSource = "Thisform.oBusObj.oData.empidnum", ;
> Height = 24, ;
> Left = 536, ;
> TabIndex = 13, ;
> Top = 38, ;
> Width = 168, ;
> BoundTo = .T., ;
> Name = "Combo1"