Text Intensive Report

[GSCaupling]

I need to create reports that are heavy on text and light on data fields. Essentially these are contracts or agreements with several paragraphs and then a few name, address and dollar amount fields.

Is it better to store the text in the report itself or import memo fields that contain the paragraphs? I don't even know how to do the first option mentioned since Labels only hold like 255 characters. What if data needs to be imported in the middle of a paragraph?

I'm using Access 2007 and Win7. Also, I prefer to generate these docs from within Access rather than deal with a mail merge in Word.

thanks

[Green]******^*******
[small]I[/small] [small]Hate[/small] [♥] [small]Ambiguity.[/small][/green]

 

[MajP]

I do not use a lot of mail merge because it is pretty limited. But if it was me I would build word templates that read from the database. I just use ADO to connect to the database. I just find you are very limited in building a report with a lot of boilerplate and formatting. However, this requires a little proficiency in vba.