Elgin,
Once your grid has been filled you can run through the columns with a for/next loop checking the width of both header text and field length with FontMetric(). Then set the column width to the larger of the two.
HTH
Barbara
>I am designing a form that has a grid where the record source is the alias of the currently open table and the column count is set to -1.
>
>I would like for the column widths to automatically adjust to the widest item in the column, either the Heading OR the widest data displayed in the column.
>
>In general, is this the proper way to design a grid of that nature? Do I have to specify a "column count" and manually set the width of each?
>
>Thanks.
>
>Elgin Rogers Jr
>Epic Solutions.