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