Ed,
it sounds like you change the recordsource of the grid like
.grid.recordsource = 'curSorName'
this will remove all columns and create new one. The newly created will know nothing about your preset.
consider the use of a CursorAdapter and bud the cursoradapter.alias to the grid.
Agnes
>Dear all,
>
>I have made a form with a grid on it and fixed all column width, but everytime I run the form with some query on data and programatically addressed the result query to be the grid recordsource, the columns width will change based on the fields length. Anyway to prevent this?
>
>Thanks in advance.
>
>Ed
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]