Charlotte Foust
charlotte.foust at gmail.com
Fri Dec 2 12:55:53 CST 2011
Just curious. What happens if one of the fields is a memo field?
Charlotte Foust
On Fri, Dec 2, 2011 at 8:27 AM, Rocky Smolin <rockysmolin at bchacc.com> wrote:
> I have had occasion to create custom spread sheets from access table data
> where TransferSpreadsheet wouldn't work.
>
> After all of the rows have been written, I use:
>
> objXLWS.Columns("A:U").Columns.AutoFit
>
> and all of the columns automagically adjust their widths to fit the data so
> when the user opens it up it looks real pretty and all the data is
> displayed
> - column set to the width of the longest value in the column - but without
> a
> lot of white space which you'd get if you tried to guess the column width
> needed.
>
> HTH somebody
>
> Rocky Smolin
> Beach Access Software
> 858-259-4334
> www.bchacc.com
>
> <http://www.bchacc.com/
>
> >
> www.e-z-mrp.com
>
> <http://www.e-z-mrp.com/
>
> >
> Skype: rocky.smolin
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
>
>
> Website: http://www.databaseadvisors.com
>
>
>