Automating column "best fit".

F

Frank Martin

I have Access2003 & WindowsXP.

I have a crosstab query to give me a debtors
trial balance, and many other crosstab
queries such as sales per year etc.

Now and then I use the right-click
"column-width best fit" to size the crosstab
columns so as to reduce the size of the
column widths.

Can this be done *automatically* so that the
columns are so sized on opening the crosstab?

Please help, Fran
 
Top