[Magienoire]

Why do Access database fields get truncated upon inserting a database table?
Is there a work-around solution?

[TedMi]

I'm not seeing this in either Office 2002 or 2003. If the data is too wide to
fit within the margins, the row height expands to allow text to wrap into
multiple lines.
Under what circumstances are your fields being truncated? How are you
inserting the table, by copy-and-paste from a datasheet view?
--
Ted

[Magienoire]

I've tried copy-paste from a datasheet view and insert database in Word (via
the insert database toolbar). The same results occurred, i.e., fields (up to
a certain length) were truncated.

It's the same problem as when you import the table into Excel. I understand
that Excel has a text length limitation on text fields. Is this the same
with Word?

"TedMi" wrote:

I'm not seeing this in either Office 2002 or 2003. If the data is too wide to
fit within the margins, the row height expands to allow text to wrap into
multiple lines.
Under what circumstances are your fields being truncated? How are you
inserting the table, by copy-and-paste from a datasheet view?
--
Ted

[Cindy M.]

Hi ?B?TWFnaWVub2lyZQ==?=,

Why do Access database fields get truncated upon inserting a database table?

This can be a function of the connection method used (the data protocol used
to transfer the data into Word). Which version of Word/Office are you working
with? Are you specifically choosing a connection method, or just using the
default?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

[Magienoire]

I'm using Office Word 2003 to insert an Access 2003 database. I don't recall
seeing a connection method option, so I assume I'm just using the default...

"Cindy M." wrote:

Hi ?B?TWFnaWVub2lyZQ==?=,

Why do Access database fields get truncated upon inserting a database table?

This can be a function of the connection method used (the data protocol used
to transfer the data into Word). Which version of Word/Office are you working
with? Are you specifically choosing a connection method, or just using the
default?

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or
reply in the newsgroup and not by e-mail :-)

[Cindy M.]

Hi ?B?TWFnaWVub2lyZQ==?=,

I'm using Office Word 2003 to insert an Access 2003 database. I don't recall
seeing a connection method option, so I assume I'm just using the default...

OK, that would mean the connection method is OLE DB. Let's try the other two that
ought to be available and see if one of them gives you a better result.

1. Tools/Options/General, activate "Confirm conversions on open".

2. Go through the steps to connect to the database table. When you select the file
and dismiss the dialog box, you should get a list that includes OLE DB, ODBC and
DDE. Try with ODBC first, then you can try with DDE (which may not work, depending
on your system's configuration). Is the result any better?

Why do Access database fields get truncated upon inserting a database table?

This can be a function of the connection method used (the data protocol used
to transfer the data into Word). Which version of Word/Office are you working
with? Are you specifically choosing a connection method, or just using the
default?



Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question or reply in
the newsgroup and not by e-mail :-)