>I'm resetting the RecordSource to "" and then to "MyTable" but the columns resize to what I think is the default size of the field lengths. What gives? I don't want to have to put a bunch of column widths into the grid. Why do they resize? Thanks!
>
>Regards, Renoir
Column resizing occurs because the controlsource was closed. If you had used custom captions for the column headers, you might have noticed that the header would default back to the field name after the pack
You might try (I haven't)
1) USE AGAIN (your DBF as the grids control source alias) syntax, and pack the "original" use's alias(), and see if a refresh forwards to the grid.
2) USe a cursor for the Grids controlsource and append the DBF to the cursor.
I think you can zap a control source without affecting the grid/column properties.
Imagination is more important than knowledge