[AccessD] Solution in search of a problem

Don't know.  Never had an occasion to export a memo field.  I've had some
very long test fields which made the column width unwieldy.  So after that
statement I adjust the long field to something reasonable and turn on the
word wrap.

R


-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Charlotte Foust
Sent: Friday, December 02, 2011 10:56 AM
To: Access Developers discussion and problem solving
Subject: Re: [AccessD] Solution in search of a problem

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
>
>
>
--
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com