I'm working in VBA and I haven't been able to figure this one out.
I have a form with a datagrid and I use a recordset to populate the fields (see code below). In VBA the grid properties window allows you to either set the defcolwidth to 0 which will use the recordset to set the column widths or specify a value and all columns will be that value.
Does anybody know how to set column widths for each individual colunm?
Set DataGrid1.DataSource = pAdoRS