>>I am creating an application utilizing a connection string to a SQL Database. How can I manipulate the order of the fields from the SQL table into a Grid? Everything I try, I get the exact order of the fields from the SQL table in the grid.
>>
>>I have even tried hardcoding the format I want after the I perform the cursorfill() command.
>>
>>thisform._grid1.column1.hEADER1.Caption="Report #"
>>thisform._grid1.column1.text1.ControlSource="OCA"
>>thisform._grid1.column1.AutoFit
>>
>>Thanks much in advance
>
>You need to set each column's controlsource to the correct AliasName.FieldName. You can do it in design time (and adjust all headers) or in run-time (form's Init).


Thank you. I got everything to work but the header adjustment. I am using:

thisform._grid1.column1.autofit

Any recommendations to make the grid column grow to actual size of the returned data?