>>I have a standard grid on a form. When the form is run, the grid appears with the column showing data as expected. If I then drag a column out of its initial location, how do I get an object reference to that column? In particular, I want to get to its controlsource.
>>
>>I've tried using the grid's activecolumn property but that doesn't work for me. For example, if I drag column5 to be in position 2 (measured relative to the left edge of the grid), ActiveColumn returns 2. What property (if any) could I use to return 5 or something that would indicate that column2 started out as column5?
>>
>>TIA
>
>
>Mike,
>
>You have to loop through the columns and find which one has ColumnOrder == ActiveColumn
>
>Something like
>
>local n
>n = -1
>with m.this
> for i = 1 to .ColumnCount
> if( .Columns[m.i].ColumnOrder == .ActiveColumn )
> n = m.i
> exit
> endif
> endfor
>
>endwith
>return m.n
>
Thanks Gregory. That's exactly what I needed.
Edward and Naomi, thank you for your input too.