wordwarp in excel after export

S

Susan

Hello,

When I export my query into excel all the formatting in excel in all the
cells text have word wrap format on them. If the column width is shorter then
the text it does not appear correctly - only the last part is showing.

What I want to know - is there someway of forcing the formatting on the text
fields, such as no word wrap, or left justified?

I am using a command button and macro on a form to export the query.

Thanks

Susan
 
S

Susan

Hey Jason,

No carriage returns in any of the data.

Example data (I've transposed it to make it readable in this post:

Barcode: 1
User Code: TV 0203 field work & TV cleanup 0304 site
Notes: Field notebook for Thala Valley site assessment 2002-03 & TV tip
cleanup site assessment/verification 2003-04.
Custodian: 4687
Container Type: -1
Container Weight: 0

Cheers

Susan
 
Top