>Hi Hilmar,
>
>I erased my grid, to start all over again.
>First I do a query on a sql table on a MS SQL server, the reslut is saved into a cursor. This cursor is being used to set the recordsource of my columns. If I set the recordsource to padr(mycursor.memo,50), I get following error : "the data source for this object must be a variable reference". What am I doing wrong ?
Not the Grid.RecordSource - that one must point to the table or cursor.
The idea is to change Column.ControlSource.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)