>>I seem to have the problem, the other way 'round. I have the century property as 1 as well as "set century on" as the default in tools/options. In the database it shows 4 year format but 2 year format in the grid...
>
>It still should be the Century property of the Text1 for the column and the Sparse property of the column itself. Or maybe your grid is in a form with a Private Datasession? You'll need to SET CENTURY ON in the Form.Load or in the DataSession.BeforeOpenTables.

Yep, that's it, since it's set in Private Datasession, the 'set century on' in the form solved the problem. Thanks.