Best way to Add a lot of text to a Report

[Ivan]

Hi,

In access, I would like a report to run that would pull information from a
query, which works fine. This report will in fact be a contract. I have a
lot of information that needs to be included in the contract after the
information from the query is input.

Thanks

Ivan

 

[Marshall Barton]

In access, I would like a report to run that would pull information from a
query, which works fine. This report will in fact be a contract. I have a
lot of information that needs to be included in the contract after the
information from the query is input.

Where is this information?

If it's in a separate table, use a text box with a DLookup
expression.

 

[Ivan]

Hi Marshall,

Right now, the information is in a MS word document. There is way to much
info to put in a text field because of the 255 character limit. I have about
4 pages of information that has to be added.

Thanks,

Ivan

 

[Steve]

Hello Ivan,

I have done a lot of projects of this type. Contract paragraphs were stored
as Word docs all in the same folder. Then to create a complete paragraph,
Word automation was used with Access pointing to the data. You can get the
Word automation code by manually doing the process in Word with the macro
recorder turned on. If desired, the recorded code can then be copied into an
Access module and modified to suit.

Steve
(e-mail address removed)

 

[Gina Whipp]

Ivan,

What about a Memo field?

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

 

[Marshall Barton]

Aside from a brief exposition of his experience, I see no
attempt to advertize or solicit payment in Steve's post.

 

[Ivan]

Hi Gina,

I didnt even know about this field.

Ill give it a try.

Thanks,

Ivan

 

[Gina Whipp]

We learn something new everyday!

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

Hi Gina,

I didnt even know about this field.

Ill give it a try.

Thanks,

Ivan