Hi Cetin
In my test form when I scroll the second half of my split grid (2 locked columns), the code tells me that the left most column is 3, but in my test column 3 is not visible?
The code steps from column3, and reports that the left is 951 not less than zero?
Not sure what i'm missing here?
Robin
>My apologies Cetin,
>
>Did I quick test & mistakenly misread the results. Will take another look.
>
>Robin
>
>
>
>>Robin,
>>Exactly that.
>>The code would return you the first 'human' visible column's 'index' after the locked columns. All you need is to:
>>
>>lnIndex = GetColumnOnLeft( thisform.myGrid )
>>oColumn = thisform.myGrid.Columns( m.lnIndex )
>>
>>Cetin
>>
>>
>>>Hi Cetin
>>>
>>>I want to know what the 1st visible column is after the locked columns, even if the user has used the vertical scrollbar.
>>>
>>>When I say visible I dont mean the property, I mean that the user can see in the grid.
>>>
>>>Robin
>>>
>>>
>>>>>If I have a grid with several columns locked, is it possible work out what the first visible column on the right of the split is?
>>>>
>>>>From
http://www.foxite.com/archives/column-locking-in-a-grid-0000198556.htm>>>>
>>>>LPARAMETERS toGrid
>>>>Local ix
>>>>With toGrid
>>>> For ix = .LockColumns+1 To .ColumnCount
>>>> If Objtoclient(.Columns(m.ix),2) > 0
>>>> Return m.ix
>>>> Endif
>>>> Endfor
>>>>Endwith
>>>>return -1
>>>>Cetin
Rob