Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

12 page Contract Report

12 page Contract Report

12 page Contract Report

Access 2003
I have a 12 page contract currently in Word. I only used data from 2 fields in a query in this report. The rest is static text. I currently mail merge to Word to print it out. I would like it to be a report in Access to make it a more seamless user experience. I am not sure what the best way to go about putting that much static text in a report. Any Assistance pointing me in the right direction is appreciated.

RE: 12 page Contract Report

Without much information, I would consider dividing the contract into sections and copying into records in a table. Then use the table in the record source of a report. Make sure you include a field that identifies the sequence of the records.

Hook'D on Access
MS Access MVP 2001-2016

RE: 12 page Contract Report

For instance, setup the table with a MEMO field and then each paragraph could be a separate record in the table? I believe I can handle this. Thanks Duane!

RE: 12 page Contract Report

That was my initial recommendation. You can use the Replace() function if you need to do some type of merge in the paragraphs.

Hook'D on Access
MS Access MVP 2001-2016

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close