>>>Is there a way to change the ColumnOrder of a grid when the number of columns is unknown until runtime?
>>>
>>>I guess a related question might be: Is there a way to programmatically change the order of table fields so that a grid with ColumnCount set to -1 would reorder itself?
>>>
>>>Any advice about grids would be greatly appreciated.
>>>
>>>Thanks,
>>>
>>>Steve
>>
>>Resetting ColumnOrder property in code for particular column, you force it to change its relative position within a grid (even if >ColumnCount=-1). Try to fire code like: Thisform.Grid1.Column1.ColumnOrder=3, and you will see immediate results (it's always helpful >to issue Thisform.Grid1.Refresh too).
>
>I tried this in a stand alone command button and it will not work. I am assuming that it is because columncount = -1. When I create a different grid from the same table but with preset columns, the command works great. Go figure.
>
>Steve
It works on my machine, so ... ??? May be you used wrong column name?
Edward Pikman
Independent Consultant