Autofill columns based on size of grid 1

[tsd30135]

I want to make the dbgrid the width of my form for readability sake. I am filling the grid with a recordset but I want the columns to take up the whole size of the grid.

If there are only 2 fields in the recordset then the 2 columns would be large. etc...

What is the best way to program this?

tsd

 

[DrJavaJoe]

Manually, analyze the data before populating then set the width like so:

DataGrid1.Columns(0).Width = SomeValue
DataGrid1.Columns(1).Width = SomeOtherValue
etc.

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[tsd30135]

Thanks for the suggestion. I want to fill the grid with columns based on the number of fields in my recordset.

If I have 5 fields in my recordset I want 5 columns to fill the grid.

tsd

 

[DrJavaJoe]

Then something like this should get you started.


for i = 0 to FieldCount - 1
DataGrid1.Columns.Add(i).Caption = FieldName(i)
DataGrid1.Columns(i).Width = OverAllWidth / FieldCount
next i

Two strings walk into a bar. The first string says to the bartender: 'Bartender, I'll have a beer. u.5n$x5t?*&4ru!2[sACC~ErJ'. The second string says: 'Pardon my friend, he isn't NULL terminated'.

 

[tsd30135]

Thanks that will help. You get a star