Skip to content

Large Amount of Text - update

Some readers suggest efficient alternatives to writing large quantities of text to a separate document, which is then imported into Word.

Several readers wrote to suggest more efficient alternatives to writing large quantities of text to a separate document, which is then imported into Word.  Robin Trew and Andrew Koch suggested using DocVariable fields, which have a limit of 64,000 characters, and Anatoly Molotkov suggested just writing the contents of the Access field directly to the Word document, using TypeText (bypassing the variable entirely), which of course is the simplest solution of all!  I guess I got carried away with passing the data through variables, but sometimes it isn’t necessary (or even desirable). 

About this author