Barbara,
Thanks for the suggestion. I'm not familiar with the FontMetric() function, but I'm going read up on it now.
Thanks
Elgin
>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.