I have built a Function that sorts columns on DataGrid1_HeadClick() event. Basically it sorts Asc if previous was Desc and Vice Versa. Problem is the data is sorted and the .Bookmark moves to the First row position, which is fine, but the Column highlight remains.
DataGrid control has always behaved this way i.e. if you click a header, whether sorting or not it highlight's entire column.
So problem is that I have built a Search function that moves the .Bookmark to appropriate row and even though I highlight the Row found, Using "DataGrid1.SelBookmarks.add FindData.Recordset.Bookmark" the Column highlight remains unless you physically fire the Row Click event.
So I end up with a Highlighted Black Cross effect ie. both Column and Row are highlighted.
So does anyone Know what Event Controls the Column highlight, and if so how to turn the blasted thing off??
I have looked everwhere on Google for this and can't find an answer.