>How do I control the column content in a grid when the grid recordsource is set to a SQL SELECT statement and the recordsourcetype is set to SQL. For example, statement retrieves 10 fields, but I only want to display 5 of the 10 on my grid, and be selective of which 5 I want to show, regardless of the order of the fields in the structure.
>
>Note the SQL portion works great, but how can I select just the fields from the result cursor to show up in the grid. In Fox 2x you could browse for fields, field1, field5, field6, etc...
>
>How do you accomplish this with the grid?
>
>Thanks in advance.

Firstly, if you will use your SQL to generate cursor and then use this cursor's alias as Grid.Recordsource you get more reliable and flexible grid. Individual column's controlsource properties should be set programmatically to display different cursor fields/expressions.