Hi!

Is ControlSource field numeric? If yes, here is a problem. Check if numeric fields widths are the same. If not, they're converted incorrectly into character value (that usually combobox use) - values much match character to character include spaces.

I also know that combobox works ok only with character data. I remember in my applications 2 years ago I used a combobox class special for grids to tie it to the numeric field. It required custom refreshing and manual updating of the data in table by numeric value converted by val() function from the combobox value.


>I have a grid w/ Table as RecordSource. In that Table I have a N(3) field I use for relation in other table. In that grid I have a column w/ combobox in it as a contol. . ControlSource of ComboBox is the same. Both have "Bound = .t.".
>
>Column Properties
> ControlSource = FirstTable.NumField
> Bound = .t.
> Sparse = .f.
>
>
>ComboBox properties
> ControlSource = FirstTable.NumField
> ColumnCount = 2
> ColumnWidths = 200,30
> BoundColumn = 2
> BoundTo = .t.
> RowSourceType = "6 - Fields"
> RowSource = "SecondTable.Name, Code"
> Style = "2 - DropDown List"
>
>When The Combo got Focus Value & DisplayValue are OK but on screen the are blank combo. And If you open the list for choosing always start from top of list (not from current value).
>
>When The Sprase = .t. The behaviour of the combo is OK but the Grid shows me a code not the Name.
>
>I try in GotFocus of Combo:
> this.Value = This.Value
> this.Refresh()
>but... :((((
>
>What I must Do?
>TIA
>
>Boris