I created a query using SQL on a OnClick event. Query is displayed in datasheet view. I would like for each time query runs, the column widths be auto sized. Data in a few columns will vary in length each time. Is this possible? I looked at columnwidths property etc., with no luck. Hoping someone here may know.
Query Code:
strSQL = "SELECT Total_List.Stock_Number, Total_List.Qty, " & _
"Total_List.Gross_Wt, Total_List.Tariff_Fraction " & _
"FROM Total_List " & _
"WHERE [Company#] = " & Com_Num
...rest of code
Grazie,
Marco
Query Code:
strSQL = "SELECT Total_List.Stock_Number, Total_List.Qty, " & _
"Total_List.Gross_Wt, Total_List.Tariff_Fraction " & _
"FROM Total_List " & _
"WHERE [Company#] = " & Com_Num
...rest of code
Grazie,
Marco
