I am working with a grid. I am running into a conflict between two options that I want for the display: I want the row that the user clicks on to be highlighted (HighlightBackcolor / HighlightForecolor), and I wany any columns in the display with .NULL. date values to display as blank.

I am using a textbox-based class for all of the columns in the grid. For the columns that contain dates, I set the NullDisplay value to ' '. In order for this to work, I must set the date columns' sparse property to .F.

In order to get the row to highlight when the user selects it, I have set the grid's HighlightBackcolor and HighlightForecolor to my desired colors, the AllowCellSelection property to .F., and the Sparse properties of the grid's columns to .T.

The columns can't have Sparse property set to both .T. and .F., so I have set all of the columns in the grid to Sparse = .T. except for those containing dates, which have Sparse = .F.

When the grid runs, the columns with .NULL. dates do show blank, but for the cells of those columns in the selected row, the background is not correct.

Of course the other columns do show the correct HighlightBackcolor and HighlightForecolor.

Is there any alternative to this compromise? Can I have both the NullDisplay I want, and have the cells in the selected row show the correct HighlightBackcolor and HighlightForecolor?

Thanks,
Jim