Unless you set up some InputMask for the columns, the sparse should not make any difference, I believe.
>I have a grid with four columns. The controlsource for each column is a field in the grid's recordsource. The sparse property for all columns is set to .T.
>
>The data source would be something like
>TYPE ITEM NO PART_NO REV
>CHG 94 ABC-1234 A
>DEL 39 DEF-1234 B
>ADD 39 XYZ-1234 C
>CHG 1 QWE-1234 D
> 2 QWE-2345
> 3 QWE-3456
>
>But the data is displaying as
>TYPE ITEM NO PART_NO REV
>CHG 1 QWE-1234 A
>DEL 1 QWE-1234 B
>ADD 1 QWE-1234 C
>CHG 1 QWE-1234 D
> 1 QWE-1234
> 1 QWE-1234
>
>I've set Sparse = .F. for all columns and that corrected the display problem, but I'm curious as to what would cause columns 1 and 4 to show values "correctly" but columns 2 and 3 show repeated values based on a record from the middle of the recordsource.
>
>We have a different screen showing exactly the same data. It uses a different grid control (VFP base class) with Sparse set .T. for all columns and showing all the data rows with the correct values. That grid has a filtered table as the recordsource while mine uses a cursor.
>
>Help for Sparse
>True (.T.) (Default) Only the Column's active cell uses the CurrentControl property setting to accept and display data. The other cells use the TextBox control if the current control for the cells is not the container object or a command button. The other cells remain empty if the current control for the cells is the container object or a command button.
>
>False (.F.) All cells in the Column object use the CurrentControl property setting to display data; the active cell accepts data. >
>I
think I understand this, but I'm not sure how to interpret it for my situation.
>
>Has anybody come across this or can shed some light on why the columns are displaying differently?
>
>Thanks.......Rich
If it's not broken, fix it until it is.
My Blog