Access Export to Word & Excel

R

Rod Makin

Anyone,

I know that this will be documented in the annuls of this newsgroup but
when I searched for it I only came up with one similar entry from PeteW. I
am trying to export to Word when I do this it all initially look fine but
when the text field wraps round, in word it seems to wrap round sooner eg

This is the text in the access preview screen of the report, at
some point the text will wrap round naturally and create a
new line of its own.

The same text when exported to word will look like this:-

This is the text in the access preview screen of the
report, at some point the text will wrap round naturally
and create a new line of its own.

This is all well and good when the text remains on the same number of line
as it does here but in some cases it starts a whole new line, and I dont
know how to stop it or fix it. Any ideas?

My other problem is exporting to Excel, the maximum amount of text in a cell
that seems to be exported is 255, is there a way around this?

Cheers in advance



Rod
 
R

Rod

The wrapping in Word is dependent on the paper size and
orientation. Try different settings to achieve the result
you want.

Sorry can't help with the Excell issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top