When you import a Microsoft access field into Microsoft word, the

[Patrick Stubbin]

I have written code that exports table fields into a word document, directly
into fields in the word document.


When the access field is > 255 characters i insert a chr(13)&(Chr10) to
split the data across multiple word fields

Looks great in access,
but when i look at the data in word it has that dreaded square graphic in
the field (in word) where the charriage return/line feed is,, how do i get
rid of this (the data is at it should be in wiord except for the sqaure
graphic???


Patrick

 

[Alex Dybenko]

Hi,
you have to replace chr(13)&(Chr10) with Chr(11), use can a select query to
do so and export it instead of table

--
Best regards,
___________
Alex Dybenko (MVP)
http://accessblog.net
http://www.PointLtd.com

 

[David C. Holley]

The square is the visual representation of the characters that you inserted.
BTW.