I am wondering if it is possible to resize the columns of a datagrid based
on the length of the values I want show in them.
One way would be to read an amount of records, get the length of the
contents and then set the width of each columns. But there must be a better
way.....I hope.

Tia

Ronnie

Ronnie,
I don't think there is a better method, unless you use True DBGrid Pro by
APEX. They have made the datagrid for Microsoft, and sell the proffesional
version. The PRO version has an AutoSize method on the column object, which
sets the size of a column so that each cell is displayed.

Pieter

I needed to do the same thing for a datagrid I was using.

I was on to sizing the grid cells by calculating the number of pixles
that the text took up and then sizing the cell to that number of pixles
plus a few extra for space.

With help from the news groups I was able to do it.

But I found that it's not pixles you have to count, but twips.

I will see if I can cut and paste that part of the code and send it to
you.

Ken